1 Reply Latest reply on Jul 16, 2006 12:20 PM by Dan Bracuk

    query of query or database

    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.

      Thanks
        • 1. Re: query of query or database
          Dan Bracuk Level 5
          quote:

          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.

          Thanks

          It would be better to just select the records you need.