Re: [PERFORM] Odd performance results - more info

2003-08-14 Thread Stephan Szabo
On Tue, 5 Aug 2003, Medora Schauer wrote: I hope this piques someones curiosity. I'd really like to know what is going on here... I think you're getting caught by the typing of constants preventing index scans. UPDATE shot_record SET trace_count = %d \ WHERE

Re: [PERFORM] Odd performance results - more info

2003-08-05 Thread Joe Conway
Medora Schauer wrote: I would greatly appreciate it if someone could run this code in their environment and let me know if you get results similiar to mine. The INT test results in execution times of 11 - 50+ secs increasing each time the test is run. The FLOAT test execution times are