Big stored procedure hangs Pervasive while executing

[alfer]

I have quite big stored procedures. I have about 10 procedures calling each other, about 800 lines. They are not recurent. When I run this procedure on small tables the work ok. When I run then on tables with about 200.000 records I receive errors about insufficient memory. Pervasive stops responding, processor usage is high (100%).

What may cause such behaviour?

I run procedure on XP or Win98 with Pervasive 2000i SP4 or SP5

 

[mirtheil]

What do these Procedures do? Are they hanging on one specific statement? If so, run that statement outside of the Procedure to see if if has the same problem. How long have you let the Procedure run? Has it ever finished? Does the Pervasive Monitor still show activity on the file (records read)?

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[alfer]

They run about two hours and about 100.000 records or less (this number is not constant). They read from a source_table, make comparisions, read/write/delete/search in loops records in other cursors, and write to a end-table.
Procedure writes to a "debug_table" information about record has been processed. After Pervasive crashes I run procedure for ONLY this record and it runs ok.
On my big table this procedure has never finished.

I didn't watch activity with monitor. I will try it.
Thanks! I hope that BIG_TABLE+BIG_PROCEDURE<>CRASH.

 

[mirtheil]

How long did you wait for it to finish? You mention a Pervasive crash, is the engine causing a GPF?
What are the specs on the machine running the engine (RAM/CPU/etc)? What about the Pervasive settings (cache, etc)?

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[alfer]

Machines are different:
-Win98/Duron 800MHz/256RAM
-WinXP HE/Celeron1300
-Win98/Athlon/256RAM
All machines have much free disk space.

I wait until an error appears.
Pervasive settings are default. I did not increace any parameters.

 

[mirtheil]

What's the exact error message that appears?

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[alfer]

I have resigned from one sub-procedure and include it in another. That has helped!

Thanks for help!