in reply to Alternative for multiple while loops to improve performance

> Let meknow if I can provide more information

Um ... where is the Perl code?

On a side note: Please consider using placeholders to avoid huge security risks.

edit

Sorry, I didn't really bother to decipher your SQL, but often performance issues are connected to missing indices on relevant fields.

Cheers Rolf
(addicted to the Perl Programming Language :)
Wikisyntax for the Monastery FootballPerl is like chess, only without the dice

  • Comment on Re: Alternative for multiple while loops to improve performance

In Section Seekers of Perl Wisdom