> The myMyIndex will only slow you down. myNumOneIndex > will help if you have queries that use the numOne column.
Hurm, yes that makes sense. it wasn't supposed to be there, but was added just incase it helped, which it didn't > What is the output from sqlite3_analyzer? Unfortunatly didn't space well :( /** Disk-Space Utilization Report For test.sdb *** As of 2005-Feb-02 22:13:52 Page size in bytes.................... 1024 Pages in the whole file (measured).... 282059 Pages in the whole file (calculated).. 282014.0 Pages that store data................. 282014.0 99.984% Pages on the freelist (per header).... 0 0.0% Pages on the freelist (calculated).... 45.0 0.016% Number of tables in the database...... 2 Number of indices..................... 3 Number of named indices............... 3 Automatically generated indices....... 0 Size of the file in bytes............. 288828416 Bytes of user payload stored.......... 135341808 46.9% *** Page counts for all tables with their indices ******************** myTable................................ 282013.0 99.984% SQLITE_MASTER......................... 1.0 0.000% *** All tables and indices ******************************************* Percentage of total database.......... 99.984% Number of entries..................... 10659384.0 Bytes of storage consumed............. 288782336.0 Bytes of payload...................... 213059020.0 73.8% Average payload per entry............. 19.9879298841 Average unused bytes per entry........ 2.90023344689 Average fanout........................ 94.18 Maximum payload per entry............. 262 Entries that use overflow............. 0.0 0.0% Index pages used...................... 1763.0 Primary pages used.................... 280251.0 Overflow pages used................... 0.0 Total pages used...................... 282014.0 Unused bytes on index pages........... 253006.0 14.0% Unused bytes on primary pages......... 30661696.0 10.7% Unused bytes on overflow pages........ 0.0 Unused bytes on all pages............. 30914702.0 10.7% *** All tables ******************************************************* Percentage of total database.......... 59.5% Number of entries..................... 2664849.0 Bytes of storage consumed............. 171823104.0 Bytes of payload...................... 135342313.0 78.8% Average payload per entry............. 50.7879857358 Average unused bytes per entry........ 6.38924982241 Average fanout........................ 94.18 Maximum payload per entry............. 262 Entries that use overflow............. 0.0 0.0% Index pages used...................... 1763.0 Primary pages used.................... 166033.0 Overflow pages used................... 0.0 Total pages used...................... 167796.0 Unused bytes on index pages........... 253006.0 14.0% Unused bytes on primary pages......... 16773380.0 9.9% Unused bytes on overflow pages........ 0.0 Unused bytes on all pages............. 17026386.0 9.9% *** All indices ****************************************************** Percentage of total database.......... 40.5% Number of entries..................... 7994535.0 Bytes of storage consumed............. 116959232.0 Bytes of payload...................... 77716707.0 66.4% Average payload per entry............. 9.72122918969 Average unused bytes per entry........ 1.73722624268 Maximum payload per entry............. 13 Entries that use overflow............. 0.0 0.0% Primary pages used.................... 114218.0 Overflow pages used................... 0.0 Total pages used...................... 114218.0 Unused bytes on primary pages......... 13888316.0 11.9% Unused bytes on overflow pages........ 0.0 Unused bytes on all pages............. 13888316.0 11.9% *** Table myTable and all its indices ********************************* Percentage of total database.......... 99.984% Number of entries..................... 10659380.0 Bytes of storage consumed............. 288781312.0 Bytes of payload...................... 213058515.0 73.8% Average payload per entry............. 19.9878900086 Average unused bytes per entry........ 2.90019757247 Average fanout........................ 94.18 Maximum payload per entry............. 61 Entries that use overflow............. 0.0 0.0% Index pages used...................... 1763.0 Primary pages used.................... 280250.0 Overflow pages used................... 0.0 Total pages used...................... 282013.0 Unused bytes on index pages........... 253006.0 14.0% Unused bytes on primary pages......... 30661302.0 10.7% Unused bytes on overflow pages........ 0.0 Unused bytes on all pages............. 30914308.0 10.7% *** Table myTable w/o any indices ************************************* Percentage of total database.......... 59.5% Number of entries..................... 2664845.0 Bytes of storage consumed............. 171822080.0 Bytes of payload...................... 135341808.0 78.8% Average payload per entry............. 50.7878724654 Average unused bytes per entry........ 6.38911156184 Average fanout........................ 94.18 Maximum payload per entry............. 61 Entries that use overflow............. 0.0 0.0% Index pages used...................... 1763.0 Primary pages used.................... 166032.0 Overflow pages used................... 0.0 Total pages used...................... 167795.0 Unused bytes on index pages........... 253006.0 14.0% Unused bytes on primary pages......... 16772986.0 9.9% Unused bytes on overflow pages........ 0.0 Unused bytes on all pages............. 17025992.0 9.9% *** Indices of table myTable ****************************************** Percentage of total database.......... 40.5% Number of entries..................... 7994535.0 Bytes of storage consumed............. 116959232.0 Bytes of payload...................... 77716707.0 66.4% Average payload per entry............. 9.72122918969 Average unused bytes per entry........ 1.73722624268 Maximum payload per entry............. 13 Entries that use overflow............. 0.0 0.0% Primary pages used.................... 114218.0 Overflow pages used................... 0.0 Total pages used...................... 114218.0 Unused bytes on primary pages......... 13888316.0 11.9% Unused bytes on overflow pages........ 0.0 Unused bytes on all pages............. 13888316.0 11.9% *** Table SQLITE_MASTER ********************************************** Percentage of total database.......... 0.000% Number of entries..................... 4.0 Bytes of storage consumed............. 1024.0 Bytes of payload...................... 505.0 49.3% Average payload per entry............. 126.25 Average unused bytes per entry........ 98.5 Maximum payload per entry............. 262 Entries that use overflow............. 0.0 0.0% Primary pages used.................... 1.0 Overflow pages used................... 0.0 Total pages used...................... 1.0 Unused bytes on primary pages......... 394.0 38.5% Unused bytes on overflow pages........ 0.0 Unused bytes on all pages............. 394.0 38.5%
