AW: AW: [sqlite] Performance question

2006-09-28 Thread Michael Wohlwend
-Ursprüngliche Nachricht- Von: Martin Pfeifle [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 26. September 2006 13:35 An: sqlite-users@sqlite.org Betreff: AW: AW: [sqlite] Performance question >Hi Michael, >could you please (re)post the exact create inex statements +primary k

AW: AW: [sqlite] Performance question

2006-09-26 Thread Martin Pfeifle
Hi Michael, could you please (re)post the exact create inex statements +primary key you used. For speeding up your query, you need an index on x only but not on id,x. Best Martin - Ursprüngliche Mail Von: Michael Wohlwend <[EMAIL PROTECTED]> An: "sqlite-users@sqlite.org"