in reply to Re: Profiling and Performance
in thread Profiling and Performance

I don't think that any individual query is slow so much as the number of queries.

After sleeping on it last night, I figured out I was always using the DBI handle instead of storing a statement handle for a prepared statement. That being said I think I will try to cache the statement handle's and see if that offers any improvement.

Replies are listed 'Best First'.
Re^3: Profiling and Performance
by andreas1234567 (Vicar) on Mar 27, 2009 at 20:35 UTC
    I don't think that any individual query is slow so much as the number of queries.
    Then shaving off a little time on each one can add up to a lot.
    • Are you using placeholders?
    • Have you considered stored procedures, possibly combining multiple operations into single?
    • Are your data properly indexed?
    • Are your tables unnecessarily large (can old data be deleted)?
    --
    No matter how great and destructive your problems may seem now, remember, you've probably only seen the tip of them. [1]
[reply]

In Section Seekers of Perl Wisdom