[sqlite] Incorrect results set?
I am thoroughly confused as to why the following simple query doesn't return the proper result set but instead returns the 15 records with a coursekey starting with '0E'. Do I need to escape something? SQLite version 2.8.15 Enter ".help" for instructions sqlite> .schema CRS_2004_001 CREATE TABLE CRS_2004_001 ( etl_extract_id INTEGER PRIMARY KEY, courseid, coursekey, status, schoolid, lowgrade, highgrade, effectdate, expdate, description, title, longtitle, etl_error DEFAULT 0 ); sqlite> select coursekey from CRS_2004_001 where coursekey = '0E120'; 0E110 0E120 0E270 0E277 0E288 0E301 0E320 0E410 0E660 0E670 0E681 0E702 0E720 0E732 0E733 Any ideas?
[sqlite] 'cating' sqlite databases
Hi, We are working on a potential architecture by which many sqlite databases are created. There may be a need to aggregate data between databases and I was wondering if it's possible to quickly just 'cat' the databases together or will they need to be recreated into a single sqlite file. Thanks, - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Slowness issues running on SCSI vs. IDE
Hi, I am currently using sqlite version 2.8.4 on RedHat Linux 7.3 on an IBM x.220 - x.345. During a recent testing on the above platforms we discovered a performance issue when using both the perl sqlite module as well as the standard sqlite client. When attempting to perform a large number of operations (inserts) on the database the process seems to get 'throttled' only being allowed 1 - 5% cpu-time and running much slower than on a similar system using IDE drives. This only occurs using sqlite and not using other scripts which perform numerous IO operations. Any ideas? - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]