Error: This thread is too old. You can't reply anymore.

Oh shit! What ever happened to NO EXCEPTIONS^?

>>40
That sounds very wrong. SELECT * FROM whatever LIMIT 50 shouldn't take that long unless it physically takes a minute to get that amount of data from the disk. If that's the case, you have misunderstood the benefit, try getting the *last* 50 rows instead.

But your query was probably more complex than that, and maybe you had no indices or referenced a large field in a WHERE or ORDER BY clause.

SQLite isn't the fastest but it will handily show a great improvement over flat files for non-sequential access.