[V4RB2] Holy crap, what a speed difference!

[Kem Tekinay]

I am converting my project from the SQL method, using a Vcursor, to the
Table method, using bitsets, and the difference is remarkable! Searches that
took over a second or two before are practically instant now. And sorts are
incredibly fast too.

Where before I was finding that the REALdatabase was similar to, or faster
than, Valentina, now I find there is no comparison, but only if I use the
Table method.

The only place where I still find Valentina slower is in retrieving data
from records in a loop, but perhaps the people at Paradigma can help me
optimize this once I'm ready to release my project.

BTW, I see that Valentina created an index on-the-fly when I sorted on a
non-indexed field. This is a very nice touch, but I wonder how I can turn
that feature off if I want to?

__________________________________________________________________________
Kem Tekinay                                                 (212) 201-1465
MacTechnologies Consulting                              Fax (914) 242-7294
545 Eighth Avenue, Suite 401                          Pager (917) 491-5546
New York, New York 10018                    http://www.mactechnologies.com

To join the MacTechnologies Consulting mailing list, send an e-mail to:
  mactechnologies_consulting-subscribe at yahoogroups.com