in reply to Re^2: Much slower DBI on RHEL6
in thread Much slower DBI on RHEL6

Hi Tux,

the focus in my proposal was on using bind variables and using a prepared statement more than once. But you're right, when someone is hunting the milliseconds, your approach should be faster.

Thank you and ++.

Best regards
McA

Replies are listed 'Best First'.
Re^4: Much slower DBI on RHEL6
by Tux (Canon) on Feb 06, 2014 at 13:13 UTC

    More than milliseconds. Last time I tested on MySQL, it was 5 to 10 times faster. (also this table where higher numbers are better)


    Enjoy, Have FUN! H.Merijn
[reply]

      Probably a big number of milliseconds... ;-)

      I start to be curious about the timings in our environment. Especially when you really want a list of hash refs as the result of a db querying function. So, is it worth to build up the hash on your own or let DBI do the stuff for you.

      Probably I have the time to investigate this question. But anyways thank you again for the link.

      Best regards
      McA

[reply]

In Section Seekers of Perl Wisdom