On Wed, April 30, 2008 17:25, 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. >> >> 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.
...and the answer is that there just as to be one unique entry. If duplicates occur then it is because someone in inputting a data file that has already been processed. > > > > -- > SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ > Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html > > -- Howard LANNet Computing Associates <http://lannet.com.au> When you want a computer system that works, just choose Linux; When you want a computer system that works, just, choose Microsoft. -- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html
