Originally posted by: dandev
I'm creating an image gallery. My database has about 1000 records with 10 column.
Now I'm realising there's a lot of trips to the database. Would it be better that when I init my app I store the "get all" query and query that from that point? Or is the difference in performance of querying a query as a oppose to a database not worth it?
If you say I should query the query, how many records would be too much to hold in memory.