Thank you all so much for your data. It will really help me a lot.
Looks like I'll be able to use SQLite in ways I had originally
anticipated would be out of scope. Well done
On Mon, 2003-11-24 at 09:06, D. Richard Hipp wrote:
> D. Richard Hipp wrote:
> >
> > Over the past 30 days, the www.
> More data:
>
> I duplicated the www.sqlite.org website on my desktop then started
> hammering on it using multiple instances of "wget -r". I ran the
> test for several minutes.
>
> During this test, every hit involved multiple SELECTs and at least
> one UPDATE against a single sqlite database fi
Richard Heyes wrote:
During this test, every hit involved multiple SELECTs and at least
one UPDATE against a single sqlite database file. The database engine
was easily able to handle a rate of over 250 (2.5M) hits/day or
about 30 hits/second. The database did not appear to be the limiting
fa
> During this test, every hit involved multiple SELECTs and at least
> one UPDATE against a single sqlite database file. The database engine
> was easily able to handle a rate of over 250 (2.5M) hits/day or
> about 30 hits/second. The database did not appear to be the limiting
> factor in thi
D. Richard Hipp wrote:
Over the past 30 days, the www.sqlite.org website has seen 6
separate 10-minute bursts of activity with 25 hits/day rates
and many 1-minute bursts in the 45 hits/day range. Rates in
excess of 20 hits/day have been sustained for a couple of
hours on one event. (M
-Original Message-
From: D. Richard Hipp [mailto:[EMAIL PROTECTED]
Sent: Monday, November 24, 2003 7:13 AM
To: [EMAIL PROTECTED]
Subject: Re: [sqlite] web server use of SQLite
D. Richard Hipp wrote:
>
> The www.sqlite.org website is run off of a single SQLite database.
> Back
D. Richard Hipp wrote:
The www.sqlite.org website is run off of a single SQLite database.
Back before I implemented bandwidth throttling, the site would
sometimes get 5 hits/day to pages that used the database.
Over the past 30 days, the www.sqlite.org website has seen 6
separate 10-minute burs
Vania Smrkovski wrote:
Have you or anyone encountered issues regarding my other questions,
that of using SQLite as a web-served DB system? How do the recently
discussed issues of concurrency and the locking of DB tables and files
affect the use of a web site delivered SQLite DB system, and is the
Darren,
Thanks for the response. I knew about this issue as a security hole,
which is why one of my options was to place the DB files out of the
entire web doc tree. Happily, you took something that I had to learn
the hard way from tech notes and experience and codified it in a way
that c
At 9:04 PM -0500 11/23/03, Vania Smrkovski wrote:
> Speaking to the first question, regarding security of data, aside from
>some of the obvious, like putting the DB files out of the web document
>tree, are there any ways to configure SQLite to keep the DB files in
>some non-readable format?
Hello,
I became acquainted to SQLite through its implementation in the
upcoming PHP version 5.0. As such, it is taking on much the same role
that MySQL used to in versions up to the current official release (still
in the 4.x range). As I understand it, one of the primary reasons is
MySQL'
11 matches
Mail list logo
