VirtualTable SaveToFile seems slow

VirtualTable SaveToFile seems slow

Postby 99Percent » Tue 16 Mar 2010 20:36

I feel like the VirtualTable SaveToFile is rather slow at least compared to previously used ClientDataSet SaveToFile.

I am saving 200000 records of about 200 bytes each and it takes about 15 seconds in a SSD hard drive (about 40MB). Is this normal, or is there a way to speed it up? LoadFromFile also seems slow.

Delphi 2007.
99Percent
 
Posts: 48
Joined: Tue 13 Sep 2005 05:34

Postby 99Percent » Thu 25 Mar 2010 15:30

Never mind the question. I was using TVirtualTable with the wrong approach - for storing a copy of the remote datebase tables. I scrapped it and used sqlite instead. Now its much faster.
99Percent
 
Posts: 48
Joined: Tue 13 Sep 2005 05:34


Return to VirtualDAC