Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
Old Nov 7, 2012, 06:58 PM   #1
Starfox
macrumors regular
 
Join Date: Apr 2011
SQLite speed woes - index not being used

I have an SQLite query that seems to be skipping an index I created on the field Time:

sqlite> explain query plan SELECT UserID, JSON FROM TweetsJSON WHERE TweetID <= 9999999 AND Time >= 1352249596 AND Time <= 1353027196 ORDER BY TweetID DESC LIMIT 100 ;
0|0|0|SEARCH TABLE TweetsJSON USING INTEGER PRIMARY KEY (rowid<?) (~27777 rows)

TweetID is a primary key and an index was created on Time using the syntax CREATE INDEX TimeTweetsJSONIndex ON TweetsJSON (Time). What's wrong here? Why is it skipping that index totally? Search times are reflecting that and they're less than satisfactory.
Starfox is offline   0 Reply With Quote

 
MacRumors Forums > Apple Systems and Services > Programming > Mac Programming

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
SQL / SQLite browser application? VideoBeagle Mac Applications and Mac App Store 2 Mar 20, 2014 03:32 PM
missing contacts, but available in backup/sqlite?! temen iPhone 0 Sep 2, 2013 03:52 PM
Sync sqlite with sql server RookieAppler iPhone/iPad Programming 2 Oct 19, 2012 12:09 PM
Slow SQLite Query Starfox Mac Programming 3 Sep 10, 2012 12:04 PM
Sqlite and Core Data kimbebot iPhone/iPad Programming 5 Jul 23, 2012 01:44 AM

Forum Jump

All times are GMT -5. The time now is 07:10 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC