*** 12,20 **** I guess you could create a view to simplify frequent querying. ------ ! Q) Are there any plans for Concurrent Queryes Improvements on SQLite??? I mean, when i'm hypothetically inserting 100000 records in a table throguh a PHP PDO Query, and I try to access this table for a simpe query like (select * from table where id = 1), SQLite returns a message that the table is locked. Is there any research for this? Is there a active project roadmap? Thanks! ------ --- 12,23 ---- I guess you could create a view to simplify frequent querying. + Alternatively, if you are using the SQLite command line program, the following works fine: + .tables + ------ ! Q) Are there any plans for Concurrent Queries Improvements on SQLite??? I mean, when i'm hypothetically inserting 100000 records in a table throguh a PHP PDO Query, and I try to access this table for a simpe query like (select * from table where id = 1), SQLite returns a message that the table is locked. Is there any research for this? Is there a active project roadmap? Thanks! ------ *************** *** 189,191 **** --- 192,196 ---- http://www.sqlite.org/datatype3.html ------ Q) Does SQLite have a prefered file type? Obviously things like .db are too generic, and file.sqlite seems just a little bit long... .sl2? .sl3? What should we use to be friendly with simple type checkers. + + A) File extensions are a predominantly a Windows phenomenon. Be careful with certain extensions as they may trigger Windows XP's system restore systems (eg. .sdb is associated with Appfix packages, which means Win XP will keep a backup copy every time it's changed - thus dramatically affecting your performance). Don't make it one of these: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sr/sr/monitored_file_extensions.asp
Small. Fast. Reliable.
Choose any three.
Choose any three.
|
|