I've made a program in Clarion that realise a lot of insert in my pervasive sql 2000 database ( about 150 000), but the problem is that after each insert, the server seems to get more and more memory reserved: after 10 000 insert, the process on the NT server is taking 200 Mo of memory. At about 240 Mo, the database process makes a fatal error on the server, and i have to reboot it. I've tried to commit after each insert, but it doesn't change anything.... (ROLLBACK AND COMMIT does not change anything... i can't use the rollback on this server, is it normal?).
Thanks for your help.
Dekeyzer Stephane.
Belgium.
Thanks for your help.
Dekeyzer Stephane.
Belgium.