 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Lluis Olle
Guest
|
 Posted: Tue Dec 16, 2003 10:01 pm Post subject: Use TKbmMemtable in memory tables |
 |
|
Hi
I highly suggest you to give a try using Kid Madsen kbmMemTable Free
component for Batch processing complex SQL querys, splittng those in several
easy to follow and logical steps.
Basically, whit this "in memory Table" component, you can do a
..LoadFromDataset from TADODataset(s) into KbmMemtable(s), define apropiate
indexes into those memory tables, and play using highly efficient indexed
accesing, ranges, ... and so on, what is your old Btrieve application is
doing just now. 150.000 records is not too much ... I usually work with more
than that in my everyday batch jobs.
Use server fastforwardonly cursors in the TADODatasets, because you only
want those for feeding the in memory tables.
I'm absolutely confident that you can reduce the processing time, not from
the "hours" is taking now, but to less that a half it uses with Btrieve (and
that's my experience), as Btrieve is not specially efficient.
Regards
|
|
| Back to top |
|
 |
Lluis Olle
Guest
|
| Posted: Tue Dec 16, 2003 10:03 pm Post subject: Re: Sorry, was in response of TADODataset VERY SLOW wih MS S |
|
|
Sorry
My previous message was in response to another thread, titled . "TADODataset
VERY slow with MS SQL ..."
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
