Does virtual table has a max number of record ?

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Edison Garcia
Posts: 29
Joined: Sat 29 Jul 2006 01:52

Does virtual table has a max number of record ?

Post by Edison Garcia » Fri 23 Feb 2007 12:58

there are any kind of maximal number of record using virtual table?
I try to use it, with the followind configuration:
1 field string / 2 fields float / 2 fields currency and 1 lookup field string
Inside a loop, I starte doing insert / moving values to the fields and post.
My surprise was that, withaprox 200 records, the virtual table, inside the loop, becomes empty and stars to receive neu records till the endo of the loop ( about 150 records). With no msgs, even fro inside IDE (Delphi 7).
To come to the conclusion that it is what was hapening, I put a counter inside the loop and found that only the last 150 records were in the table at end.
Thank you Edison Garcia

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Fri 23 Feb 2007 15:43

No, TVirtualTable does not have any limitations on row count. Row count in TVirualTable is only limited by size of the system virtual memory.
Please send me a complete small sample at evgeniyD*crlab*com to demonstrate the problem. Also supply me with exact version of MyDAC. You can see it in the About sheet of TMyConnection Editor.

Post Reply