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
Orignally there were but in the process of trying to figure
out what is going on I stripped everything out of the database
except the table being queried.
>
> "Medora Schauer" <[EMAIL PROTECTED]> writes:
> > I have a table with a 3 column key. I noticed that when I
> update a non-key field
> >
"Medora Schauer" <[EMAIL PROTECTED]> writes:
> I have a table with a 3 column key. I noticed that when I update a non-key field
> in a record of the table that the update was taking longer than I thought it
> should. After much experimenting I discovered that if I changed the data
> types of two
I have a table with a 3 column key. I noticed that when I update a non-key field
in a record of the table that the update was taking longer than I thought it
should. After much experimenting I discovered that if I changed the data
types of two of the key columns to FLOAT8 that I got vastly impr
