VirtualTable SaveToFile seems slow

99Percent · Post by **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 · Post by **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.