Hi Just wondering if anyone has heard of Flash adding time to queries?
I have a query that is taking almost 5 seconds on a database in Flash, yet when I put the same query into SQLite Administrator with that database loaded, it takes 15ms. I set up a flash timer, and start it just before... sqlStatement.execute(-1, new Responder( pass, fail )); ... and stop it and trace it as soon as Flash hits pass(); - so there's nothing else going on apart from the query to eat up time. The database has an index that is being used according to EXPLAIN QUERY PLAN in SQLite Administrator. Does Flash use the same SQL code? It's as if it's ignoring the index. Here's the query (I know there are a lot of COLLATE NOCASE statements - it's because my current table columns are not COLLATE NOCASE, and I'm not yet ready to set up a new table that has COLLATE NOCASE columns to copy the data into): SELECT * FROM (SELECT * FROM table1 WHERE col1 !="" COLLATE NOCASE ORDER BY col1 COLLATE NOCASE , col2 COLLATE NOCASE ASC, col3 COLLATE NOCASE ASC, col4 COLLATE NOCASE ASC ) UNION ALL SELECT * FROM (SELECT * FROM table1 WHERE col1="" COLLATE NOCASE ORDER BY col2 COLLATE NOCASE ASC, col3COLLATE NOCASE ASC, col4 COLLATE NOCASE ASC) LIMIT 10 Thanks for your thoughts. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
