Exporting and importing are too slow.
Exporting and importing are too slow.
VirtualTable is very useful to process non relational tables.
It makes almost ideal performance.
most operations are very fast!
(also, it is free of chage. )
but, exporting and importing(**) are too slow
when record count grows up.
Can I tune up my lovely VirtualTable's poring performance?
-------------------------------------------------
here is my operation condition.
57 fields. (integers, vchars)
100,000 records. (over full load)
208 seconds elapsed. (SaveToFile() or SaveToStream(memorystream))
49.6 MB (file.vdb)
-------------------------------------------------
**
SaveToFile()
LoadFromFile()
SaveToStream()
LoadFromStream()