> > > > 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. > > Perhaps better to put a unique index on the appropriate column(s), then > just do an insert and throw away the error if the data is already there.
Yes, even better! I was going to ask Howard whether it mattered whether the data was different or whether it just had to be one of them. -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
