Intermitten problems like this are always hard to track down. It sounds like what you're doing is really straight-forward, so here are some suggestions/questions:
* Have you gone through the CF and particularly the SQL code to make sure it's as efficient as it can be? * What kind of hardware is it running on? * Is it strictly a load/hardware issue or can it sometimes flake out with a low number of users? * Is the database running on a separate physical server than the CF server? * If the database and CF are on separate servers, what's the connectivity between them? Internal to a datacenter or does it go across the internet? 9 times out of 10 if it isn't load/hardware related, the culprit is going to be the database performance. First check your queries then evaluate the hardware setup to see if there are any bottlenecks there. Then you might try a different driver for the database--I've seen some extremely nice speed improvement in some cases when using the jTDS driver for SQL Server as opposed to Microsoft's, for example. Which MySQL driver are you using? What version of CF is this running on? Matt On 1/27/06, Kevin Fricke <[EMAIL PROTECTED]> wrote: > I have a problem. > > We have an order form where a number of different tours can be purchased. > When the item is purchased, the submit page inserts the order into the > database, inserts the client information into the client table and updates > several detail tables. At the end it send the receipt etc. > > We are have some intermittent performance issues. Is there are better way > to optimize this page? Should I split it into a couple of different pages? > > > How you would your recommend writing a page that was performing a number of > different database operations. We are currently using mySQL 4 so stored > procedures are out of the question. > > Any help will be tremendously appreciated!! > > Thanks, > > Kevin > > > > _______________________________________________ > Reply to DFWCFUG: > [email protected] > Subscribe/Unsubscribe: > http://lists1.safesecureweb.com/mailman/listinfo/list > List Archives: > http://www.mail-archive.com/list%40list.dfwcfug.org/ > http://www.mail-archive.com/list%40dfwcfug.org/ > DFWCFUG Sponsors: > www.HostMySite.com > www.teksystems.com/ > -- Matt Woodward [EMAIL PROTECTED] http://www.mattwoodward.com _______________________________________________ Reply to DFWCFUG: [email protected] Subscribe/Unsubscribe: http://lists1.safesecureweb.com/mailman/listinfo/list List Archives: http://www.mail-archive.com/list%40list.dfwcfug.org/ http://www.mail-archive.com/list%40dfwcfug.org/ DFWCFUG Sponsors: www.HostMySite.com www.teksystems.com/
