RE: [sqlite] How fast is the sqlite connection created?

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

Re: [sqlite] How fast is the sqlite connection created?

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

RE: [sqlite] How fast is the sqlite connection created?

, 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

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 connection related and is lost when you close the connection so it's a very real-world valid comparison. no surprise that connect()

Re: [sqlite] How fast is the sqlite connection created?

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

RE: [sqlite] How fast is the sqlite connection created?

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

RE: [sqlite] How fast is the sqlite connection created?

' 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

RE: [sqlite] How fast is the sqlite connection created?

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

Re: [sqlite] How fast is the sqlite connection created?

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

RE: [sqlite] How fast is the sqlite connection created?

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 &

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 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

Re: [sqlite] How fast is the sqlite connection created?

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

Re: [sqlite] How fast is the sqlite connection created?

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

Re: [sqlite] How fast is the sqlite connection created?

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

[sqlite] How fast is the sqlite connection created?

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? -- powered by python