i created an index but the query still slow and here are the schema
Qt Code:
  1. CREATE TABLE b11430
  2. -- This table created by SQLite2008 Pro Enterprise Manager
  3. -- Osen Kusnadi - http://www.osenxpsuite.net
  4. -- Created date: 2010-09-24 19:47:33
  5. (
  6. id INTEGER,
  7. nass TEXT,
  8. part INTEGER,
  9. page INTEGER
  10. );
  11. CREATE UNIQUE INDEX idx ON b11430(id);
To copy to clipboard, switch view to plain text mode 
is there a solution?