Database retrieval using mercator

[mlapse]

I was wondering whether mercator provides the caching functionality for Database stataments and information extracted from the database.

I went through the DB Interface Guide and read about the bind statement. However we have many cases where certain information needs to be extracted repeatedly from the database and used frequently.

Is there a facility in mercator which enables us to store the results of a query in the memory? Also could we specify how long the results should be kept in the memory before a refresh by executing the same SQL again.

 

[BocaBurger]

Every map execution is unique. You could write the data to a file and use that file until you refresh it. Keeping it in memory might be faster, until someone's query resulted in 2 gig of data



BocaBurger
<===========================||////////////////|0
The pen is mightier than the sword, but the sword hurts more!