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 " \ > "WHE

Re: [PERFORM] Odd performance results - more info

2003-08-14 Thread Medora Schauer
> 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 executi

[PERFORM] Odd performance results - more info

2003-08-14 Thread Medora Schauer
I didn't get any helpful responses to my previous email so I thought I would try again, this time with example code. Below is my orignal email and code for a dead simple ASCII menu driven application that demonstrates the problem. The app starts up with a menu of 4 items to create the test data

Re: [PERFORM] Odd performance results - more info

2003-08-09 Thread Medora Schauer
> > > 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 FL

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 consistentl