Devart Forums

Does FetchAll do anything when changing the property in a MyTable? My response time is much faster when setting MyQuery fetchall = false. MyTable - fetchall = false seems to do nothing?

Before you call MyTable.Open when FetchAll=False, MyTable doesn't "know" about size of the table on the server and starts fetching records from the server. To define number of rows that will be transferred across the network in single step, you should set FetchRows option. Pay attention that in FetchAll=False mode an additional connection to the server is created. FetchAll=False mode also has some restriction. You can read about them in MyDAC help. We do not advise you using this mode needlessly.