PDA

View Full Version : Is there a way to retain the data held in mysql result datatype??



bera82
21st March 2006, 12:43
hi,
My application retrieves data from mysql database which ranges from 2,000,000 to 10,000,000 records. Now, i need this data for computation throughout the lifecycle of the application with multiple iterations through these records!

The "Result" datatype of mysql which holds the result of these query, does not hold these values for more than one iteration. I can't use a List or vector to store these values as system might go really low on memory and performance is a major factor in embedded systems.
Please help!!
I am in a fix!!
regards,
Bera

jacek
21st March 2006, 12:54
Maybe the database could do the computations for you?