And I have seen that CGI::Session is not very fast, even when there are only
a few sessions in a MySQL table, but... are there any other libraries that
can do it better?
I have seen that CGI::session is made in such a way that anyone can write a
driver for another databases or ways of storing data
>
> Also ask yourself if you really need all of the data at
> once. You may be able to filter it down in the query or
> build some incremental data structures using row-by-row
> iteration instead of fetchall_arrayref.
Ya I do, it's basically a customer list export from the database that
I write o
Is there a way to do large queries that return lots of data without
having my apache process grow by the equivalent size in ram of the
data returned?
Yes. Many databases support sending the results a few rows at a time
instead of all at once. For specific advice on this, you might check
your DBD
> > Yes. Many databases support sending the results a few rows at a time
> > instead of all at once. For specific advice on this, you might check
> > your DBD documentation or ask on the dbi-users list. You can also have
> > your program schedule the current apache process to exit after finishin
Perrin Harkins wrote:
Chris Ochs wrote:
Is there a way to do large queries that return lots of data without
having my apache process grow by the equivalent size in ram of the
data returned?
Yes. Many databases support sending the results a few rows at a time
instead of all at once. For specific
Chris Ochs wrote:
Is there a way to do large queries that return lots of data without
having my apache process grow by the equivalent size in ram of the
data returned?
Yes. Many databases support sending the results a few rows at a time
instead of all at once. For specific advice on this, you mi
Is there a way to do large queries that return lots of data without
having my apache process grow by the equivalent size in ram of the
data returned? The only thing I can think of is to run a separate
script outside of mod perl for queries like this.
Chris
hmmm... prefork.pm was created for this sort of problem, when some form
of run-time loader is being silly, and everything should really just be
loaded in at compile-time.
I wonder if it's time to investigating adding autoloader support to
prefork.pm some how.
For anyone else that has issues at
Hi,
Well, the problem was my fault. :/ I had a bug in a generic base class
I use that makes it easier to build classes that work both inside and
outside mod_perl.
For those of you who are interested, this solutions works well. By
using PerlChildInit handler to create a thread to maintain a sh
On Mon, 2005-01-17 at 20:39 +, Ian McDonald-ONLINE wrote:
> > What happens if you remove the () after "use Time::Piece" in
> > your script?
>
> It crashes with the same "can't locate" error on "use Time::Piece",
> instead of on "Time::Piece->import". I separated them out to clarify
> when a
Hi Perrin,
Thanks for the feedback. I've been meaning to find a better alternative.
I think many programmers writing standard cgi scripts are scared off
from using the Apache::Session modules because of the chosen namespace,
although I understand that it's possible to use them outside of Apache.
M
On Fri, 2005-01-14 at 13:08 -0800, Skylos wrote:
> My first suggestion based on a migration the company I work for did
> not too long ago would be to use apache2 in thread mode. There was a
> staggering drop in system memory resources consumed when we made the
> shift - from most of a gigabyte to
> -Original Message-
> From: Perrin Harkins [mailto:[EMAIL PROTECTED]
> Sent: 17 January 2005 20:31
> To: Ian McDonald-ONLINE
> Cc: modperl@perl.apache.org
> Subject: RE: [mp1] Problem with loading Time::Piece at startup
>
>
> What happens if you remove the () after "use Time::Piece" i
On Mon, 2005-01-17 at 19:12 +, Ian McDonald-ONLINE wrote:
> To be clear, I am not splitting the modules. My intention is to pre-load
> all of them; the module has not been split into *.al files, and when I
> trussed the Apache process, the startup.pl script was reading
> Time/Piece.pm (which ha
On Mon, 2005-01-17 at 14:45 -0500, William McKee wrote:
> On Sat, Jan 15, 2005 at 08:15:31AM -0500, Michael Peters wrote:
> > CGI::Session does not appear to be well maintained. It's very popular
> > and I know many people who have tried to send in patches and fixes but
> > the author has been
On Sat, Jan 15, 2005 at 08:15:31AM -0500, Michael Peters wrote:
> CGI::Session does not appear to be well maintained. It's very popular
> and I know many people who have tried to send in patches and fixes but
> the author has been unresponsive.
Which is really ashame since it's listed in the P
Another good idea... :)
But I am transfixed by this problem... I can't seem to get each forked
apache server to have both a shared global hash between all cloned
interpreters, *and* one thread in each process that runs in the
background doing housekeeping. I can think of numerous things that th
Thanks for answering, Perrin.
To be clear, I am not splitting the modules. My intention is to pre-load
all of them; the module has not been split into *.al files, and when I
trussed the Apache process, the startup.pl script was reading
Time/Piece.pm (which has all the functions in it). It cannot
On Sat, 2005-01-15 at 18:31 -0700, [EMAIL PROTECTED] wrote:
> Would you recommend squid or mod_proxy?
I would recommend mod_proxy because you already know how to run apache,
and it can run useful things like mod_rewrite, mod_ssl, mod_auth_tkt,
etc. I benchmarked them a VERY long time ago and foun
On Mon, 2005-01-17 at 11:52 +, Ian McDonald-ONLINE wrote:
> The use of any Time::Piece function or method falls back to AutoLoader,
> which tries to load the .al file.
> The interpreter cannot find the .al file, and issues a fatal
> error.
This probably means you have a permissions problem on
On Mon, 2005-01-17 at 11:25 -0500, Richard F. Rebel wrote:
> Unfortunately, it's high volume enough that it's no longer possible to
> keep these counters in the databases updated in real time. (updates are
> to the order of 1000's per second).
I would just use BerkeleyDB for this, which can easil
On Sat, 2005-01-15 at 21:57 -0500, Todd Finney wrote:
> Have you checked ::MySQL against Apache::Session::DB_File? My experience
> is a couple of years out of date on this, but I switched away from using
> ::MySQL for sessions because it was such a pig.
MySQL will be a lot faster than the tied
Hello,
I have a high volume application that basically needs to keep track of a
couple counters for the number of times certain requests were made and
update a MySQL db.
Unfortunately, it's high volume enough that it's no longer possible to
keep these counters in the databases updated in real ti
> It's a fairly new feature. If you find the documentation lacking, please
> do submit a documentation
> patch ;-) (Or did you have a specific question about
> PerlPostConfigRequire ?)
What I meant was that I didn't find anything indicating that it should
behave differently than, say, PerlRequire.
Hi,
I have a problem using Time::Piece with mod_perl.
If Time::Piece is loaded on startup, either by startup.pl, in
PerlModule, or by being used in another module. It appears in %INC.
In a cgi-perl script running under Apache::Registry:
'use Time::Piece' does not cause the file to be re-read.
%T
[Long report!]
-8<-- Start Bug Report 8<--
1. Problem Description:
This is OS X (10.3) with their standard perl, CompleteApache2 and
mod_perl-2-RC3
Running make test shows some failures:
Failed Test Stat Wstat Total Fail Failed Lis
26 matches
Mail list logo