Re: [sqlite] Re: attached databases

Igor Tandetnik wrote: select ID, TimeFrom, TimeTo, Events from db1.tableName where Events=:event union all select ID, TimeFrom, TimeTo, Events from db2.tableName where Events=:event union all select ID, TimeFrom, TimeTo, Events from db3.tableName where Events=:event order by TimeFrom;

[sqlite] attached databases

Hello, As I understand it, you can attach databases together with sqlite and then perform 1 query on all the databases together. I have this situation where I have 3 disks, and every disk contains a database, and each of those databases has the same structure: ID, TimeFrom, TimeTo, Events

[sqlite] more mem needed?

Hello, I am doing about 10 inserts now in a transaction. My temp storage is set to be on disk to prevent using much memory. I was wondering if more memory is needed when I would do 50 inserts in a transaction, or is this all the same, as the temp_store is set to be on disk? thanks for the

Re: [sqlite] sqlite.org organization...

Jay Siegel wrote: For example, using google I accidentally found http://www.sqlite.org/php2004/slides-all.html which is Yeah, I found this also accidentally while browsing the older news section(because I use 2.8.16), and found it immediately very interesting. It deserves to be on a better

[sqlite] records sorted or not

Hello, If I do a select query, and that query uses an index, will the results come out sorted like the index? Or is that random? Kind regards, Tom

[sqlite] Re: query 31 days

Ramon wrote: Have you tried putting the yearmonth in 2 different columns, not sure if it will be any faster, but I think it will, due to being a lot of them repeated. Check you bandwidth and see if it's enough for your web users to access this query remotely. Peace I will try this, thanx

[sqlite] query 31 days

Hello, I'm using SQLite 2.8.16, on an embedded system, and I have a question. I have a database with one table, containing all my records. Each has a field 'yearmonth' which contains for example '200508', and also a field 'date', which indicates the day of that month. I want now to make an