DBD::mysql and profiling

Hi,
I'm writing a program that uses DBI/Mysql and does a
*lot* of selects and inserts/updates. (One short run
did 2809 and 5714 respectively).

I've used Devel::DProf with it - in an attempt to get
an idea of any performance problems - and am getting
some interesting data on test runs. One thing that
looks odd is:

Total Elapsed Time = 362 seconds
User+System Time = 3.2 seconds

Now I'm not running anything special apart from the
program here. Is it likely to be the MySQL engines
themselves, with all those SQL statements, taking all
that time?

I did have a MySQL GUI running for this but running
with this turned off brought the Total elapsed time
down to 334 seconds. Not a great improvement. The
MySQL table being used is near 30000 records.

(Am running ActivePerl 5.8.6 on XP)

TIA for any help,
Henry




___________________________________________________________
How much free photo storage do you get? Store your holiday
snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com

Re: DBD::mysql and profiling

http://search.cpan.org/src/TIMB/DBI_AdvancedTalk_2004/sld022 .htm
http://search.cpan.org/~timb/DBI/lib/DBI/Profile.pm

Tim.

On Mon, Dec 12, 2005 at 03:03:09PM +0000, Henry McGuinness wrote:
> Hi,
> I'm writing a program that uses DBI/Mysql and does a
> *lot* of selects and inserts/updates. (One short run
> did 2809 and 5714 respectively).
>
> I've used Devel::DProf with it - in an attempt to get
> an idea of any performance problems - and am getting
> some interesting data on test runs. One thing that
> looks odd is:
>
> Total Elapsed Time = 362 seconds
> User+System Time = 3.2 seconds
>
> Now I'm not running anything special apart from the
> program here. Is it likely to be the MySQL engines
> themselves, with all those SQL statements, taking all
> that time?
>
> I did have a MySQL GUI running for this but running
> with this turned off brought the Total elapsed time
> down to 334 seconds. Not a great improvement. The
> MySQL table being used is near 30000 records.
>
> (Am running ActivePerl 5.8.6 on XP)
>
> TIA for any help,
> Henry
>
>
>
>
> ___________________________________________________________
> How much free photo storage do you get? Store your holiday
> snaps for FREE with Yahoo! Photos http://uk.photos.yahoo.com