On Wed, 2008-04-30 at 12:30 +1000, Matthew Hannigan wrote: > > > You do a select before every insert?! Is the table indexed? > If not that might explain the slowdown; a select WILL take > longer the bigger the table.
Also when adding 100K records the stats for the table could become incorrect quite rapidly; this can lead to bad query plans even on an indexed table. But I'm guessing this is being done in a single transaction which is not nice to the database :P -Rob -- GPG key available at: <http://www.robertcollins.net/keys.txt>.
signature.asc
Description: This is a digitally signed message part
-- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
