0

It seems fetchArray runs the query again, this makes it feel sluggish with complex SELECT queries.

Is there someway to have the database cache the 1st query it gets and just give the same results the second time?

Improve this question
3
  • If there were, it wouldn't have this bug. Commented Jun 2, 2017 at 0:55
  • It would be possible to change PHP's sqlite3 module to do this caching. It would also be possible to replace PHP with some other language. Which one is easier for you is something you have to decide yourself. Commented Jun 2, 2017 at 8:55
  • If I were to use mysql would I have this issue? Commented Jun 2, 2017 at 11:58
Related questions
0
php sqlite_fetch_array corrupted results
0
Problems with SQLite and PHP arrays
4
PHP and SQLite 3, multiple returned row
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.