> I dunno but it still pisses me off that it still gets errors on its > queries taking to long to run (with a whopping 13 items in the store). > I let it go on a shared server but on a very nice ded server it still > does it.. not as often but even on a shared server with a 50 second > time out limit it shouldn't error, especially with only 13 items.
I have yet to find any indication that timeouts have anything specifically to do with the software, it seems to be a ColdFusion/database issue. I have many users that never get timeouts at all. In fact on my own site, I tend to get timeouts on my blog running BlogCFC more often than I do on the webstore area (I maybe see one timeout a month at most on the store). I've also run my site on BlueDragon, and did not have any timeout issues on that server. The timeouts when they do come up are totally random and more often than not, are tables that have small numbers of records, and very simple queries, so there's no logical explanation for why it would timeout, from a software perspective. Keep in mind that once CF hands off the thread to the database driver, anything that might cause that to not return is going to result in a hanging thread and eventually a timeout. Here's a good blog entry on looking for the cause of such a problem: http://mkruger.cfwebtools.com/index.cfm/2006/5/17/hanging.threads.network.capacity ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:247838 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
