New answers tagged sqlite
Running EXPLAIN QUERY PLAN on your query gives this: 0|0|0|SCAN TABLE LEGS AS l 0|0|0|EXECUTE LIST SUBQUERY 1 1|0|5|SEARCH TABLE TRAVELDAYS AS d USING AUTOMATIC PARTIAL COVERING INDEX (Day=? AND Value=?) 1|1|4|SEARCH TABLE TRAINS AS t USING AUTOMATIC COVERING INDEX (TrainDaysUID=?) 1|2|0|SEARCH TABLE LEGS AS l USING AUTOMATIC COVERING INDEX (TrainUID=?) ...
When the order of pages in the file has no relation to the order of pages on the disk, reordering the file does not make sense.
They just properly normalize their database so that it is possible to store an arbitrary number of numbers; something like this: CREATE TABLE Contacts ( ContactID INTEGER PRIMARY KEY, Name TEXT ); CREATE TABLE PhoneNumbers ( ContactID INTEGER REFERENCES Contacts(ContactID), Number TEXT );
Aftee searching the Ideone FAQ, it seems that it uses Sqlite3 for the SQL language. Sqlite needs PRAGMA foreign_keys = ON; to enable foreign keys checks. As they say in their docs: SQLite Foreign Key Support : Assuming the library is compiled with foreign key constraints enabled, it must still be enabled by the application at runtime, using the PRAGMA ...
Top 50 recent answers are included