Jonathan Field wrote:
> Hi all,
>
> I've noticed that under mod_perl any die() (or croak()) calls get
> rewritten with a timestamp, a loglevel flag, and escaped newlines before
> going to the error log. For example, under CGI if I call die("hello")
> from a script called foo.cgi I get:
>
> hel
Original Message
From: Perrin Harkins <[EMAIL PROTECTED]>
Subject: Re:Database transaction across multiple web requests
Date: Mon Apr 03 2006 03:55:54
How do you know it isn't just the operating system caching the disk
fetches? The docs certainly make it sound like a query ca
How do you know it isn't just the operating system caching the disk
fetches? The docs certainly make it sound like a query cached with
LIMIT will not be useful when different LIMIT values are applied.
Because I run it from the command line, and Windows ain't that smart.
Trust me. :)
- Pe
I missed part of the initial discussion so sorry if this isn't quite what
you're looking for, but if you're talking about the query cache (the one
that caches the exact query and the exact results), this output can be
useful:
mysql> show status like "Q%";
+-+--+
On Mon, 2006-04-03 at 10:28 +0800, Foo Ji-Haw wrote:
> Perrin Harkins wrote:
> > Jeff wrote:
> >> Your application simply uses approach (b) and MySQL does the rest
> >> automatically. So if you
> > Have you tried this? I was under the impression that MySQL would just
> > stop when it finds enou
Perrin Harkins wrote:
Jeff wrote:
Your application simply uses approach (b) and MySQL does the rest
automatically. So if you
Have you tried this? I was under the impression that MySQL would just
stop when it finds enough row to satisfy LIMIT, so it wouldn't cache
the whole result set.
I have
Hi folks,
I'm looking to improve a pretty large mod_perl app I have, which
currently uses statically configured method handlers like so:
httpd.conf:
PerlModule My::Module (creates an instance of itself as
$My::Module::Persistent )
PerlAccessHandler $My::Module::Persistent->acce
Frank Wiles wrote:
> On Fri, 31 Mar 2006 14:47:37 +0200
> Issac Goldstand <[EMAIL PROTECTED]> wrote:
>
>> Granted, I use a few MySQL features for this; I'm not sure if LIMIT
>> exists in postgresql, and I'm fairly sure that the SQL_CALC_FOUND_ROWS
>> directive (which will return the total rows i
