Protoculture wrote: > > Essentially what is happening is we've broken down our email sendouts into > smaller groups. This was done before I came here, but I assume it was done in > this manner to make the chunks more managable and to be able to monitor the > progress of the entire system. ( ie... we get a confimation after each batch > ). > > I would take a guess that the queries that search for related data to a > specific client is what is slowing the whole thing down.
Does your boss consider your guesses good enough to justify an investment/upgrade decision? Or does he want *proof*? > ( It seems to take the better part of a day to send out 40,000+ ) emails.... > I dont know, but that seems excessive to me. Of course I couldn't really say > as I've never worked on a email list of this size before. Perhaps this is the > norm. If queries take the longest time, changing CF won't help. Changing the SQL or the database would help. Get numbers on what takes how long. Us guessing based on your guesses is a waste of time. > As I've mentioned before, the way this has been set up is on CF Developer > Edition along with scheduled tasks for each group of 1000 clients. This is > the system that I have inherited. Are you now admitting to running Developer Edition in production on a public mailinglist where you know several Macromedia employees are member? If I were you I would drop everything and first write a memo to the boss alerting him to that and recommending him to call the BSA to schedule a license audit. Just in case they start looking for someone to blame. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:201970 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
