>Store the query and creation time in the Application scope? Is that a memory problem, or does it work the same as caching queries normally? I would think the latter has some automatic management while the former can lead to problems?
Is the mysql cache another option? I'm just changing from an access db so I don't know what approach to take. By the way, why exactly does cfqueryparam prevent caching? The query still looks the same in the end using some custom cf check or cfqueryparam check. Why didn't MM work around whatever the problem is? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http://www.adobe.com/products/coldfusion/flex2/ Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:270164 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4