• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Querying a Query

Another way to help reduce load on a database and increase performance is to query an already existing recordset. This saves a trip to the database because the specific information from the original query is already in memory. Imagine, for example, being able to query your product catalog once, save the results to memory, and then let users perform searches on the query results rather than the database. Here, you are going to create a simple example of this feature in action.

NOTE

Typically, you would store your original query to an application variable to keep it available. However, since we are not going to cover application variables in this book, you will see the querying of queries in action but not actually save your initial query to memory.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint