I'm building a store which constantly adds and removes designers as product availability dictates. My navigation page contains two dB calls - one for designers and one for product categories. (If there are no items in a particular product category then the category does not appear.) I'm trying to determine best way to reduce excess dB calls and have the best usability. Can't use a CFCACHE based on time as there is no way to predict when the store runs out of an item or adds a new designer. The two directions I thought of was 1. set the time frame to something huge (100 days) and every time the dB is updated run queries to see if there are any new designers, categories or if the number of items listed for a designer equals zero. If there are any changes flush the cache and update the table with number of designers and categories. There may be usability issues here. Example: a designer that is usually represented is not displayed for a while - customers may fear that the store is no longer carrying that designer. It may be better to display a "no items" notice. 2. Assuming the client chooses to display "no items" it may be better to bring in human judgment into decision making. Let the customer and his staff flag which designers are "active" and then click a "publish" button which will use CFFILE action="write" to create a static nav page. I'm leaning towards the second choice. Realistically it can be assumed that there would be 5-10 changes per month, which is not too much for an actively involved staff (3 people) to cover. As much as I hate the idea of "Sorry we're temporarily out" it may be better than confusing the customer by removing designer X from the list.
Gilbert Midonnet ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:241211 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
