That's good you are using a prepared query , but are you closing the cursor
every time? Don't. Keep it around and just rebind and execute. Otherwise
you are not taking full advantage of the prepared query. Also look to see
if you can eliminate some indexes. More indexes, slower insert performance.
Also if you are inserting multiple rows at a time use the array interface.
Jim
"Miko" <poncz_at_hotmail.com> wrote in message
news:3b8c19dd.0210010059.195752b2_at_posting.google.com...
> My web server does ~1000 insert query per second (many index on the
tables)
> But all the queries are the same (same query different parameters)
> Is there any possibility to speed up the queries?
> (I am already using preperstatment for each query.)
>
> Thanks,
> Miko
Received on Tue Oct 01 2002 - 06:34:58 CDT
