Devart Forums

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.

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.