On Tue, 5 Oct 2004, Kazuho Oku wrote:
>From: "Christian Smith" <[EMAIL PROTECTED]>
>
>The apache module I am writing is an access controller. It queries the
>SQLite database and send different contents to clients depending on their IP
>addresses / cookies.
So it's a simple table lookup based on
From: "Christian Smith" <[EMAIL PROTECTED]>
> There is going to be some performance penalty, but if it's only 1% of your
> request time, you'll have complicated your design for very little
> performance gain.
>
> Always perform benchmarks to back up your assumptions. I'm not saying your
> assumpti
On Wed, 29 Sep 2004, Kazuho Oku wrote:
>From: "Christian Smith" <[EMAIL PROTECTED]>
>> On Tue, 28 Sep 2004, Kazuho Oku wrote:
>
>> >Unfortunately, my apache module only performs a single SELECT clause of
>> >which WHERE clause can be indexed.
>> >What I am wondering is the way to stop calling SQLi
From: "Christian Smith" <[EMAIL PROTECTED]>
> On Tue, 28 Sep 2004, Kazuho Oku wrote:
> >Unfortunately, my apache module only performs a single SELECT clause of
> >which WHERE clause can be indexed.
> >What I am wondering is the way to stop calling SQLite each time the
module
> >processes an HTTP r
On Tue, 28 Sep 2004, Kazuho Oku wrote:
>Thank you for the response.
>
>Unfortunately, my apache module only performs a single SELECT clause of
>which WHERE clause can be indexed.
>What I am wondering is the way to stop calling SQLite each time the module
>processes an HTTP request (eliminate the F
From: "D. Richard Hipp" <[EMAIL PROTECTED]>
> Kazuho Oku wrote:
> I think you are asking for SQLite to preserve its memory cache
> and not reload pages from the disk as long as the database is
> unchanged.
>
> SQLite version 2.8 does not support this and probably never will.
>
> The file format f
Kazuho Oku wrote:
Unfortunately, my apache module only performs a single SELECT clause of
which WHERE clause can be indexed.
What I am wondering is the way to stop calling SQLite each time the module
processes an HTTP request (eliminate the FLOCK -> READ -> FUNLOCK done by
SQLite).
I think you are
Thank you for the response.
Unfortunately, my apache module only performs a single SELECT clause of
which WHERE clause can be indexed.
What I am wondering is the way to stop calling SQLite each time the module
processes an HTTP request (eliminate the FLOCK -> READ -> FUNLOCK done by
SQLite).
# sor
8 matches
Mail list logo