2 Replies Latest reply: Jun 23, 2015 8:42 AM by Colin Albert RSS

    Reduce Model Size - OLEDB connection

    Rovika Poole

      Hi,

       

      I have a model that is connected through an OLEDB connection to SQL.

      I have loaded 1 table, which contains 11million rows. The model is extremely slow and takes a while to refresh objects after every click.

      I have already trimmed the table in SQL, is there any other way to speed up the model?

       

      Would it be more efficient to load it as a flat file as opposed to plugging it into SQL?

       

      thank you for your assistance!