Re: [sqlite] Version 3.2.3

Khamis Abuelkomboz wrote: D. Richard Hipp wrote: Version 3.2.3 of SQLite is now available on the website http://www.sqlite.org/ In addition to fixing a lot of minor bugs, this release adds a number of important new enhancements. Most of the enhancements are centered around the much-improved

Re: [sqlite] Version 3.2.3

D. Richard Hipp wrote: Version 3.2.3 of SQLite is now available on the website http://www.sqlite.org/ In addition to fixing a lot of minor bugs, this release adds a number of important new enhancements. Most of the enhancements are centered around the much-improved query optimizer, but there

Re: [sqlite] Re: sqite2.8 performance snag when filesize grows more than 70MB on a 256MB ram

D. Richard Hipp wrote: I am running on linux, and I will need this to scale to at least 200,000 rows If you upgrade to the vary latest code in CVS (version 3.2.2+) and you create an index like this: CREATE INDEX idx ON table(parent_name, name); Then the query above should be very

Re: [sqlite] Strange performance problem

sn't create an index for primary keys that are not "INTEGER" :-) But haven't verified it yet. khamis Michael Gross wrote: Khamis Abuelkomboz wrote: CREATE INDEX idx_t2_t1id ON t2 (t1id, deleted); Doent not help. whereas the following quere takes "no" time: SELECT COUN

Re: [sqlite] Strange performance problem

Michael Gross wrote: Hello I use sqlite 3.2.2. I have a strange performance problem. I am able to solve the problem by a slight change in the query but I want to ask if somebody can explain this behavior to me: I have two tables: CREATE TABLE t1 (id VARCHAR(40) NOT NULL PRIMARY KEY,

Re: [sqlite] Index and General Optimization Question

John Sample wrote: Hello all. I'm a new Sqlite user porting a large db for an open source project from SQL Server. I have a question regarding whether an index makes sense or will be used for a certain scenario. Since the table in question is so large it takes up to 8 hours for me to create

Re: [sqlite] Index and General Optimization Question

Kurt Welgehausen wrote: Currently, indices are not used to look up either term in an OR expression. See . You could build 2 separate 5-column indices and use a union. Regards his is not true. databases split usually queries into several sub

Re: [sqlite] query 31 days

Khamis Abuelkomboz wrote: Hi How many records contain your table? Your select command scans all the table entries and I guess that the database uses the standard index. try the following command to tell the db which index it should use: select distinct date from mytable where yearmonth

Re: [sqlite] query 31 days

Hi How many records contain your table? Your select command scans all the table entries and I guess that the database uses the standard index. try the following command to tell the db which index it should use: select distinct date from mytable where yearmonth = '200508' order by date

re: [sqlite] Query locking up SQLite

David Fowler wrote: Query 2: SELECT * FROM table1, table2 WHERE ((table1.value LIKE "%value%" AND table1.table2_id = table2.id) > OR (table1.value LIKE "%different_value%" AND table1.table2_id = table2.id)); This query (and even more complex versions of it) works in MySQL (Haven't tried

[sqlite] how to get last autoincrement value?

Hi I'm using SQLite in my application and am very excited about this little and fast database. How can I retrieve the last created autoincrement value? On MySQL and SQLServer or just the SQL standard I can fire the following select statement: SELECT @@IDENTITY Is there a similar way to do