RE: RES: Performance Question.

2002-10-06 Thread Ed Carp
> Don't forget that MySQL is the fastest thing on the planet for your (and mine) > kind of simple query and insert/updates. We measured 12 times faster > performance in MySQL than Oracle in one part of our application, and I > strongly believe that in the MySQL case the Java program overhead becam

Re: RES: Performance Question.

2002-10-06 Thread Niclas Hedhman
On Monday 07 October 2002 11:32, Robert H.R. Restad wrote: > Thanks for doing the test :) Don't forget that MySQL is the fastest thing on the planet for your (and mine) kind of simple query and insert/updates. We measured 12 times faster performance in MySQL than Oracle in one part of our appli

RES: Performance Question.

2002-10-06 Thread Robert H.R. Restad
45 seconds to create 120 000 MyISAM table char rows? Thats a pretty nifty speed. PHP have a considerable overhead compared to new versions of Java. (I use both languages... I prefer PHP for webpage generation, but Java for serverside applications) I am hesitant to dig into C++ just to solve this

RES: Performance Question.

2002-10-06 Thread Robert H.R. Restad
The amount of updates will vary from time to time. Sometimes I imagine there will be 200-300 records to update, but for the most time maybe 10-50 records. The mathematical system I will create is in a way recursive... You check Record #1 - how many records in the database has similar values. Afte