Re: *solved* Re: [ACFUG Discuss] Re: Speeding up execution time against 2.3 m records

2006-09-09 Thread Derrick Peavy
Thanks. And um, just for the fun factor, let me tell you what that's running on::Apple Dual G5 X Serve with 8 GB RAM, Blue Dragon 6.2, Apache 1.3 and MySQL 4.1.13 _  Derrick Peavy Sales and Web Services  Universal Advertising Phone: 404-786-5036 Fax: 404-370-0470 

*solved* Re: [ACFUG Discuss] Re: Speeding up execution time against 2.3 m records

2006-09-08 Thread Derrick Peavy
The final solution was/is much simpler. However, there is still a query speed advantage with PHP. A colleague ran the same queries, on the same model machine, using the same MySQL DB, and MySQL version, only difference was PHP and the query times were much, much faster. How much? Well, after

Re: *solved* Re: [ACFUG Discuss] Re: Speeding up execution time against 2.3 m records

2006-09-08 Thread Cameron Childress
On 9/8/06, Derrick Peavy [EMAIL PROTECTED] wrote: 0.5MS). You can see the CF page here: http://www.universaladvertising.com/atest.cfm That page indicates results for my query in 0009. ms the first time around and .0030 milliseconds for subsequent requests.pretty freakin fast.

[ACFUG Discuss] Re: Speeding up execution time against 2.3 m records

2006-09-07 Thread Cameron Childress
without seeing all the php and cf setup info and code I don't know. maybe, maybe not On 9/7/06, Steven Ross [EMAIL PROTECTED] wrote: Would that still be the reason for the huge slowdown between php and CF? I would think there would be something else there causing that... just curious. On