x27;ll have to try it all
yourself. I guess it varies per person as well, depending on skills and
needs. Some systems might offer more features, while others will give you
more control. It's what you want and need that matters, not what others
think you should use (although I'll wholehartedl
At 13:02 10-2-00 +0200, Stas Bekman wrote:
>On Thu, 10 Feb 2000, Leslie Mikesell wrote:
>
>> According to Ryan, Aaron:
>>
>> > We found that we are quicking using up the max connections to the MySQL
>> > database
>> > and when we raise the max connection, the performance gets worse. What
was
>>
ellent. If you can afford
it I highly recommend all the old issues as well, it really has
some marvellous stuff in there - I learned a lot from it.
Now if only there were more than 4 issues a year ...
Grtz,
Pascal
--
Pascal Eeftinck - arcade^planet.nl
arcade^xs4all.nl - Perl is not
tables are unlocked. If your
session die()'s while tables are locked, they will stay neatly locked as
your connection won't be closed either This was a nasty one I bumped
in to ...
Grtz,
Pascal
--
Pascal Eeftinck - arcade^planet.nl
arcade^xs4all.nl - Perl is not a language, it's a way of
life
ve. If you can optimize or take away some of
your heavy queries that's a good start, as any database connection
can be potentially quite heavy.
BTW, there is at least one advantage of having MySQL on the same
machine as your webserver, if you connect without specifying a
hostname (not even localhost!) you'll get unix sockets instead of
TCP sockets, and they're supposedly a bit faster. By how much I do
not know. If anyone wants to benchmark this I'd love to hear
about your findings. :)
Grtz,
Pascal
--
Pascal Eeftinck - arcade^planet.nl
arcade^xs4all.nl - Perl is not a language, it's a way of
life
ompile new 32 bit files
against old 32 bit libraries, and thus you have to make it all in the old
32 bit format. One of the joys of IRIX. :/
Grtz,
Pascal
--
Pascal Eeftinck - arcade^xs4all.nl - Perl is not a language, it's a way of life
At 09:37 10-11-99 -0500, William R. Lorenz wrote:
>ModPerl List,
>
>Forgive me if this is offtopic, but I am attempting to paginate a set of
>returned SQL records using mod_perl connecting to a MySQL server (through
>DBI/DBD::mysql). I believe this can be accomplished using the RANGE() SQL
>funct
ball effect. I'm sure once I'm done converting the heavily
used scripts to HTML::Mason and implementing a lot of caching there
the load on the MySQL server will be a lot less and leave room for the
useful stuff. :)
As someone else already mentioned, the MySQL people are working hard on
mak
ld system had (or lacked). Reducing the number
of queries to 1 per request instead of some 6 queries per request really makes
a difference in my test configurations. Not in the least because it will allow
your database to serve other more useful queries instead.
Grtz,
Pascal
--
Pascal Eeftinck - arcade^xs4all.nl - Perl is not a language, it's a way of
life.
