Page 1 of 1
slow opne large table
Posted: Fri 19 Mar 2010 22:35
by inageib
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
Posted: Fri 19 Mar 2010 23:09
by tobias_cd
Look in help for TUniQuery and "FetchAll" option (set it to False)
Posted: Sat 20 Mar 2010 00:28
by inageib
it is false of course !!
Posted: Sat 20 Mar 2010 01:16
by inageib
sorry my devexpress grid is slowing this down, however any other suggestions are welcome
thanks
Posted: Sat 20 Mar 2010 07:16
by malinsky
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
Posted: Sat 20 Mar 2010 11:15
by inageib
yes yes I fixed that I meant what are the best practice for loading data using unidac ?
thanks
Posted: Mon 22 Mar 2010 11:30
by Dimon
Set the GridMode property to True.