Re: few newbie quesitons..

2007-05-29 Thread Jay Buffington
I'm a little behind here, but this thread caught my eye: On 5/6/07, Perrin Harkins <[EMAIL PROTECTED]> wrote: On 5/6/07, James. L <[EMAIL PROTECTED]> wrote: > my question is > once the app produce the html, does the memory > allocated by the parsed data get released to perl? > that memory will b

Re: Memory Usage

2007-03-30 Thread Jay Buffington
> My main problem is: Memory Usage. > Currently, the apache processes take (each) about 150 MB memory, > what's quite a lot. Now, i've been wondering which module and why it > takes that much memory at all. Check out this thread: http://aspn.activestate.com/ASPN/Mail/Message/modperl/3173671

Re: Using Apache::DBI

2006-09-07 Thread Jay Buffington
This solves a problem I was having some time ago while implementing ecommerce (verisign): 1. insert customer's info 2. authorize credit card 3. log authorization response to database 4. if auth fails roll back #1, but keep #3 I was planning on solving this problem using Oracle's AUTONOMOUS_TRAN

Re: Using Apache::DBI

2006-09-07 Thread Jay Buffington
Reviving a thread 4 months later... On 5/10/06, Perrin Harkins <[EMAIL PROTECTED]> wrote: On Wed, 2006-05-10 at 10:26 -0700, Jay Buffington wrote: > At first I was caching the database handle myself when running outside > of mod_perl. In mod_perl I was relying on Apache::DBI r

Re: different default oracle date formats under mod_perl and scripts

2006-08-26 Thread Jay Buffington
Thank you all very much. As mentioned, this isn't a mod_perl issue. That NLS_ variable sounded familiar. I looked in my httpd.conf and found this: PerlSetEnv NLS_LANG american_america.we8iso8859p1 Which controls (among many other things) the default date format. I've moved that line out of the

different default oracle date formats under mod_perl and scripts

2006-08-25 Thread Jay Buffington
Hi, I'm using DBI with DBD::Oracle. I've noticed that under scripts the default date format is mm/dd/ HH24:MI:SS, where as under mod_perl the default returned date format is -MM-DD. That is, if I select a date column from the database without wrapping it in a TO_CHAR() function, I get d

Re: Tracking down memory hogs

2006-06-23 Thread Jay Buffington
On Thu, 2006-06-22 at 11:20 -0700, Jay Buffington wrote: I'm considering writing a PerlLogHandler that will print out the memory usage (using GTop) before and after each request so I can find the offending code path. I wrote this script and it turned out to work very well. It's s

Tracking down memory hogs

2006-06-22 Thread Jay Buffington
Hi, I've been looking for a good technique to find out what module is using all my memory. Imagine some sneaky user creates this module: package MemoryHog; my %big_hash; sub handler { my $r = shift; foreach (1..1_000_000) { $big_hash{$_} = $_ * 5; }

Re: Using Apache::DBI

2006-05-10 Thread Jay Buffington
I want my modules to be able to get a the same database handle anywhere they need it during a single request (if under mod_perl) or the life time of the script they're in. At first I was caching the database handle myself when running outside of mod_perl. In mod_perl I was relying on Apache::DBI

Apache::FakeRequest for automated tests

2006-04-18 Thread Jay Buffington
Hi, I have a handful of fairly simple mod_perl 1 handlers that I want to test. I've tried using Apache::FakeRequest, but its lacking in a lot of areas. After subclassing it I was able to write a test that looked for the correct headers_out, but it was a pain and kind of sloppy. Does a more comp

Re: how to share data among modperl processes

2005-10-20 Thread Jay Buffington
Even if you are in a multiple server environment you should still be able to use Cache::FastMmap. You'll just have to make sure that the global param share_file is a file that would be shared to all servers (perhaps over an NFS mount). Jay On 10/9/05, Pratik <[EMAIL PROTECTED]> wrote: > Unless