Click to See Complete Forum and Search --> : Database Operations is too slowness


Dj^Hoke
August 19th, 2004, 04:29 PM
Hello to all... you pardon me for my not perfect English,
I am working on a database access in c++ with the WinAPI, a database of approximately 8 mb, it is I have a slowness problem and I would want to know like being able to optimize the operations since I execute update also of 13800 rows;
thanks for the aid that you will give;

Dj^Hoke

Bond
August 19th, 2004, 04:33 PM
Can you post the C++ line or the SQL statement that is taking so long to run? It will be easier to help if I know what you're doing.

Dj^Hoke
August 19th, 2004, 04:48 PM
Hello Bond , Which Part of Code do you want to post ? the code i too long

Bond
August 20th, 2004, 08:21 AM
Well, which part has the "slowness problem?" Have you stepped through your program with the debugger to see what could be slowing you down? Are you performing a number of operations in a loop? Have you commented out lines to see if it speeds things up?

Dj^Hoke
August 20th, 2004, 09:10 AM
Thanks Bond ,

Reflecting on the problem, I have thought that the slowness is due to the fact that reads many lines, and when I make it to recreate the index rewrites all the numbers for approximately 13000 times, hour I try to make the debug steps in order to see the point exact of the problem.
Do You want that it past the code of the two functions? being still expert I do not even have store clerk some error or the code can even be shortened in order to render it faster;

makes to know me

Google Translator Support :)