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 DO.T com
_______________________________________________
Valentina mailing list
Valentina@lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
©2005 Kem Tekinay |
