Viewing posts from March,
17 years, 6 months ago
Spent a good deal of time today learning about MySQL's limits when it comes to non-indexed tables. I had 4 column table which included a date, IP address and 2 integers. The CFMX server started going bananas, taking a long time to finish requests. I lowered the timeout, so long running requests would die and I increased the number of simultaneous requests in the ColdFusion administrator from 8 to 100! the server would eventually use all 100 connections and then start queuing requests, then die. Finally I decided to check out our MySQL database server, which is never the problem, and found tons of locked queries trying to select/insert/update into my 4 column table.
In Fusebox4.1 it's impossible to achive the ideal directory structure for MediaPost.com. I'd like to have n different sites, two for now, mediapost.com and publications.mediapost.com, each having a different fusebox.xml.cfm so that they have their own circuits (which may point to the same physical folder) share a Application.cfm file, so a user session can span the two sites. Because the Fusebox4.1 core (fusebox.xml.cfm) depends on the name attribute in the cfapplication tag this doesn't work. It's supposed to be fixed in Fusebox5.0, according to Hal Helms.
Finally, after months of work, and 2 weeks of labor and pushing, we've finally launched the new MediaPost.com website
using CFMX 6.1, FuseBox 4.1 and MySQL on a DELL computer running Windows 2003 Enterprise Server. The site was moved from a really old computer running NT, CF5 and Microsoft SQL Server.