I've been exploring SQLite for a number of applications, but one I'd like to
embark on soon is using SQLite to record Web site log file data, so I can
perform SQL-based analysis on my logs, rather than using some thing like
Analog.
Unfortunately, each Web access on the server is likely to be in
You cannot even consider loading even a thousand records directly.
Get a set of ID numbers. Load each record as it's needed. This is very
basic stuff, and not even that hard to implement. I am just saying for
the record that this is not hard to do, hopefully no one else will be
scared away from
If you pre-sort the data prior to inserting into sqlite you will
see much better timings for both the default cache size and
the larger cache size.
When I run your script (unmodified, except for the removal of
MySQL) up to 40:
tablesize sqlite sqlite-largecache
0 1.956 1.956
--On Friday 27 October 2006 15:31, [EMAIL PROTECTED] wrote:
> When a table is indexed, INSERT performance is logorithmic in the
> number of rows in the table and linear in the number of indices.
> This is because entries have to be inserted into the index in
> sorted order (otherwise it
On 10/28/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I am doing it on Windows. Hence permissions shouldn't be a problem.
NTFS has permissions too. Sysinternals' FileMon utility may be
useful, as it will show exactly what is going on in terms of file I/O.
I am doing it on Windows. Hence permissions shouldn't be a problem.
Regards,
Ravi K
-Original Message-
From: Lloyd [mailto:[EMAIL PROTECTED]
Sent: Saturday, October 28, 2006 4:49 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Regarding sqlite3_open
Which platform are you using?
Hi all,
Is it possible to make requests on a database created with 2.8.(14 or 17) with
an (tcl) API developped for sqlite 3.0?
I am still trying to find a way to create/have acces from OpenWatcom Fortran.
Since I noted that the version 2.8.14 of sqlite can be compiled with Openwatcom
(is it also
Which platform are you using? Do you (application) have enough
permission to create files in the specified location ?
On Sat, 2006-10-28 at 16:19 +0530, [EMAIL PROTECTED] wrote:
> Hi All,
>
> I am using sqlite3_open() in my program. It is returning
> error code 14(file not found)
Hi All,
I am using sqlite3_open() in my program. It is returning
error code 14(file not found) every time.
Where does it search for the file? I even tried with the fully qualified
path, Also placing the file in the working directory. Even if the file
does not exist, it should create
Hi
Thanks for the reposnse. The main reason is my record count could be from a
few thousands to a million. But even at the lowly numbers of around 1
the interface can seem slugish if you read every record before displaying
anything.
As you mention, and has been disucssed above, doing stuff
10 matches
Mail list logo
