Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database App Memory Optimization

Status
Not open for further replies.
Guest_imported

Guest_imported

New member
Jan 1, 1970
0
Hi

I have an application that logs data real-time to a MySQL database using BDE/ODBC. The problem i have is that the data I log runs into +- 200,000 records, which I then need to pull and analyse. Using the query object, when I pull the data off, memory utilization on my local machine jumps by +- 100MB! Is there any method of optimizing this process so that I don't end up chewing memory on the local machine.

Thanks
 
Status
Not open for further replies.

Similar threads

emailx45
  • Question
How to create a simple and easy Splash Screen for VCL application?
Replies
1
Views
220
emailx45
emailx45
emailx45
  • Question
How to catch "MOUSE CLICK/MOVE" in any place on screen ( IN or OUT form area / application) using MouseHookProc() - my way >:)
Replies
0
Views
138
emailx45
emailx45
Glenn9999
  • Locked
  • Question
Fixing "Out of Memory" error 1
Replies
2
Views
286
Glenn9999
Glenn9999
Praful Wadkar
  • Locked
  • Question
Sqlite Database Connection in Multi device application (Android)
Replies
1
Views
356
majlumbo
majlumbo
JordanSandersPr
  • Locked
  • Question
Support for 64-bit Android App Development in EntityDAC
Replies
1
Views
165
Boris777
Boris777

Part and Inventory Search

Sponsor

Back
Top