slow opne large table

inageib · Post by **inageib** » Fri 19 Mar 2010 22:35

Hello,
I open interbase 2007 table contain 1000,000 record and it take about 35 seconds to open it, while I used to use another company component I open this table instantly , what I should do to speed it up ?

thanks

tobias_cd · Post by **tobias_cd** » Fri 19 Mar 2010 23:09

Look in help for TUniQuery and "FetchAll" option (set it to False)

inageib · Post by **inageib** » Sat 20 Mar 2010 00:28

it is false of course !!

inageib · Post by **inageib** » Sat 20 Mar 2010 01:16

sorry my devexpress grid is slowing this down, however any other suggestions are welcome

thanks

malinsky · Post by **malinsky** » Sat 20 Mar 2010 07:16

Hello,

no problem of UniDac. See help topic "Grid Mode" and "Data Loading Modes" in DX help. See also http://www.devexpress.com/Support/Center/p/B92991.aspx and more solution in DX knowledge base.

PMal

inageib · Post by **inageib** » Sat 20 Mar 2010 11:15

yes yes I fixed that I meant what are the best practice for loading data using unidac ?

thanks

Dimon · Post by **Dimon** » Mon 22 Mar 2010 11:30

Set the GridMode property to True.