in reply to How can I improve the sql statements applying efficiency

well, let's see the script that you're using to read the SQL.
Efficiency in this case may not just be about the script your using, however. It could very well be how those SQL statements are structured, what they are doing, and how your data is set up in the DB. I've just got nothing to go on here to even begin to answer your question. Please re-ask and I'd love to help. How (Not) To Ask A Question
  • Comment on Re: How can I improve the sql statements applying efficiency

Replies are listed 'Best First'.
Re^2: How can I improve the sql statements applying efficiency
by littlehorse (Sexton) on Jul 24, 2010 at 03:48 UTC
    Since the script is not written by me, my purpose was to get some direction guide lines here, maybe I should dig into the script and come here again, thanks for your advice.