Re: [sqlite] Index performance using 2 integers vs. 1 float

Kosenko Max wrote: > > > I think it's better to try go with single integer. It perfectly fits range > 12:00:00 midnight, January 1, 0001 Anno Domini (Common Era) to 11:59:59 > P.M., December 31, A.D. (C.E.) in 100 nanosecond units. And it's good > idea to store all dates in UTC. > >

Re: [sqlite] Index performance using 2 integers vs. 1 float

Simon Slavin-2 wrote: > > > We can't give you much idea because . . . > Another aspect is which fields you need to retrieve when you do your > SELECT. If your select needs to retrieve the time field, and the time > field doesn't appear in the index it's using, it will need to read the

[sqlite] Index performance using 2 integers vs. 1 float

Hello, We use a julian.decimal format to represent date/time (i.e. noon of August 26, 2009 would be 40049.5000) and we use this julian date for an index key. Our databases are frequently up to 3GB in size containing 10 million records with 15 assorted field types per record and contain 6 months

Re: [sqlite] 100 million records will be fine?

Yes, that does help me. Thank you for sharing! -Dan Rajesh Nair-5 wrote: > > I have a real time program which logs more than 30,000 records, each > record of about 200 bytes, per day and the company in which it has > been installed is working 24/365. I installed the project on 2005 > August

[sqlite] 100 million records will be fine?

Hi. I've started a SQLite C++ project that could peak at 100 million records (250 bytes per record spread over 20 fields) and would like to ask if anyone has seen SQLite projects of this magnitude. The Windows data logging project will add up to 1 million records per day and run queries

[sqlite] Problem using Attach to insert data from another table

Hi. I battling my way through the Attach command and I can't get my simple test to work. Given a database named "ultra2008.sql" that contains a table named "ultra" and a database named "archive2007.sql" that also contains a table named "ultra" where the databases and tables have identical

Re: [sqlite] Possible to use field names instead of index offsets in queries?

Thank you for your help- I understand it better and can work it out now. -- View this message in context: http://www.nabble.com/Possible-to-use-field-names-instead-of-index-offsets-in-queries--tp17461475p17511500.html Sent from the SQLite mailing list archive at Nabble.com.

[sqlite] Possible to use field names instead of index offsets in queries?

Hi, Without using a wrapper, is there a simple way of accessing a query's results using field/column names instead of index offsets? For example, instead of: strcpy(DeptCodeStructure[i-1].DeptName, result[i*ncols+1]); Something more like: strcpy(DeptCodeStructure[i-1].DeptName,

Re: [sqlite] Is there direct (non SQL) table access?

Now that I know it's not easily doable, I'll just use an update statement. Thanks for saving me a lot of time guys! -Dan -- View this message in context: http://www.nabble.com/Is-there-direct-%28non-SQL%29-table-access--tp16075825p1608.html Sent from the SQLite mailing list archive at

[sqlite] Is there direct (non SQL) table access?

Is it possible to access a table without a SQL query? I've been searching and haven't found a way. I'd like to do something like this: sqlite3 *pDB = NULL; // database pointer FILE* fp = fopen("people.db","a+"); sqlite3_open("people.db",); // Pseudo code that I need help with follows...