TED]
Sent: Thursday, March 01, 2007 10:50 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How fast is the sqlite connection created?
A cursor is the thing that you use to run your queries. Eg in Python's
wrappers you import the wrapper (library, module) Connections to the
database and cre
Samuel R. Neff wrote:
Eric,
Sorry if this is obvious to everyone else but not to me.. what exactly is
cursor()? I don't see it anywhere in the C API and the wrapper I'm using
(SQLite .NET) doesn't have any corresponding method.
A cursor is the thing that you use to run your queries. Eg in
, February 28, 2007 9:30 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How fast is the sqlite connection created?
Samuel R. Neff wrote:
> Some of this performance gain is probably related to caching data and
query
> plan, not just opening the connection, but still that caching is
conn
Samuel R. Neff wrote:
Some of this performance gain is probably related to caching data and query
plan, not just opening the connection, but still that caching is connection
related and is lost when you close the connection so it's a very real-world
valid comparison.
no surprise that connect()
Samuel R. Neff wrote:
One last set of performance numbers for opening a connection. :-)
All points on the curve. ;)
So the impact of open/closing connections on a real-world db really is huge.
You're right, that's a huge difference. Good bit of benchmarking there.
These tests with
One last set of performance numbers for opening a connection. :-)
This is after adding in check constraints for types and foreign key triggers
(which may only be used during development anyways).
Non-Pooled: 17,515.6 ms
Pooled with Reset :562.5 ms
Pooled without
'
Subject: RE: [sqlite] How fast is the sqlite connection created?
I ran some tests and received fairly drastic results. Our schema has 67
tables right now (once we add in the history tables, it'll have about double
that) and 116 indexes, excluding the automatic primary key indexes.
I ran 1,000
is in the Washington D.C. metro area. If interested
contact [EMAIL PROTECTED]
-Original Message-
From: Martin Jenkins [mailto:[EMAIL PROTECTED]
Sent: Monday, February 26, 2007 12:53 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How fast is the sqlite connection created?
Samuel R. Neff wrote
Samuel R. Neff wrote:
Thank you for the testing and information.
;)
When I have time to run some tests using our actual schema (120+ tables,
several hundred indexes) I'll post back here in case others are interested
in our results. From your tests it looks like more complex schemas probably
Message-
From: Martin Jenkins [mailto:[EMAIL PROTECTED]
Sent: Monday, February 26, 2007 10:58 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] How fast is the sqlite connection created?
Martin Jenkins wrote:
> So the difference in connect times between a database with 1 table and
&
Martin Jenkins wrote:
So the difference in connect times between a database with 1 table and
10 tables is ...
It appears that adding indexes (and triggers?) increases the time at
about the same rate as adding tables. That is a connect/first select to
a database with 1 table and 3 indexes
Peter van Dijk wrote:
every time you open an sqlite database file, the sqlite library has to
parse all table structures. It is much better to keep your
connection/handle open for longer periods of time.
On my XP box it takes about 220us to connect to an SQLite database from
Python, whether
On Feb 25, 2007, at 10:03 AM, Alex Cheng wrote:
I want to know how many time is spent when create a sqlite
connection. Is it
effeciency? My application creates a connection and close it when
access DB
everytime, is it OK?
Hello Alex,
every time you open an sqlite database file, the
Alex Cheng wrote:
Hi,
I want to know how many time is spent when create a sqlite connection.
> Is it effeciency? My application creates a connection and close it
> when access DB everytime, is it OK?
Going by your sig, here are the times for Python 2.5 running under XP
SP2 on a 1.6GHZ
14 matches
Mail list logo