Search the web
Sign In
New User? Sign Up
memtable · Discuss the use of kbmMemTable and associated BCB/Delphi components.
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Hear how Yahoo! Groups has changed the lives of others. Take me there.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
New to MemTable, and some performance tests   Message List  
Reply | Forward Message #6029 of 6065 |
Setup: D7, MemTable 5.5, dbExpress, Oracle.

I have a table with about 10,000 records reasonably column density.

It takes just under a second to do this

SQLQueryPlus1.Open;
while not(SQLQueryPlus1.Eof) do SQLQueryPlus1.Next;

basically retrieving all records to the client.

Then a do this

kbmMemTable1.EmptyTable;
kbmMemTable1.LoadFromDataSet(SQLQueryPlus1,
[mtcpoStructure,mtcpoProperties]);

This takes about 4.5 seconds. Does this seem right (slow)?








Fri Jan 6, 2006 7:53 pm

bsstmiller
Online Now Online Now
Send Email Send Email

Forward
Message #6029 of 6065 |
Expand Messages Author Sort by Date

Setup: D7, MemTable 5.5, dbExpress, Oracle. I have a table with about 10,000 records reasonably column density. It takes just under a second to do this ...
bsstmiller
Online Now Send Email
Jan 14, 2006
8:48 pm
Advanced

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help