Performance of Text tables is relatively slow. This is due to two
things. First, it is relatively slow to read and parse a text
row, compared to binary rows in CACHED tables. Second, the
default amount of allocated cache is small.
You can speed it up a lot by increasing the cache for each text
tab
Hi,
I wanted to use HSQL DB Text table for querying on flat files. I had no problem
to start using it, documentations were very helpful.
My files were all huge files and can go upto few million records. I initially
tried with small volumne file and performance was good.
When I tried with a
