Recordset in Application Object

Results 1 to 2 of 2

Thread: Recordset in Application Object

  1. #1
    Mike Binnix Guest

    Default Recordset in Application Object

    I manage an application with a complex of information to be searched and accessed.<BR><BR>Essentially it is a hierarchical (sp?) index of page categories and subgategories. The theoretical depth is infinite although in practice it is rarely more than 5 - 7 layers deep.<BR><BR>Obviously the recursive join is quite complex. I&#039;ve got the query running fine. But it is a bit of a processor hog.<BR><BR>As the catalog does not change frequently I could easily be cached. Can I cache recordset object returned by the query into the application object, or do I need to convert it some other data object such as a set of arrays?<BR><BR>Thanks

  2. #2
    Join Date
    Dec 1969

    Default Easy, by converting it with GetRows

    You *could* use the RecordSet.Save method to convert it to XML text and the put that into an Application variable value, but if you have ever used GetRows you know how good its performance is. <BR><BR>So just convert the RecordSet to an array in one single method call and presto! You are ready to roll.<BR><BR>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts