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
> 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
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
>
> > 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
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