Running a same query multiple times?

Running a same query multiple times?

kaitenz
CI
Posts: 61
Threads: 16
Joined: Jul 2018
Reputation: 2

09-12-2018, 08:34 PM

Another question guys.

I want to create a query that will select ALL the rows from a database table and put/cache the result to an array property (<- is this correct?).
Then when I need a specific row, instead of running the query, I'll just pull it out from that array (the keys would be the rowId).

Is this OK? Huh

Let's say I have 2,000+ rows in my table. Is it bad to put all 2,000+ rows in a single variable/property?

Messages In This Thread

Running a same query multiple times? - by kaitenz - 09-10-2018, 10:47 PM

RE: Running a same query multiple times? - by ignitedcms - 09-10-2018, 11:33 PM

RE: Running a same query multiple times? - by Pertti - 09-11-2018, 12:31 AM

RE: Running a same query multiple times? - by php_rocs - 09-11-2018, 05:42 AM

RE: Running a same query multiple times? - by kaitenz - 09-11-2018, 08:01 PM

RE: Running a same query multiple times? - by kaitenz - 09-12-2018, 08:34 PM

RE: Running a same query multiple times? - by php_rocs - 09-13-2018, 07:38 AM