On 04/21/2016 09:58 AM, Cowboy wrote: > On Wednesday 20 April 2016 01:49:08 pm Mike Carroll wrote: >> Nice. I'm not a database guy, but I think it's generally more efficient to >> let the server do as much work as possible rather than transferring records >> "across the wire" to your script and doing it there. > > I've seen ( noteably Wordpress plugins ) people query the server for values, > then take minutes to do data manipulations in interpreted scripts which the > server could have done in milliseconds ( or less ) if the query were > constructed properly. >
I believe you. In the first script, I put the mysql output in a temp file and read every line of it for every cart and did the math. Took 10 minutes to go through about 1100 carts. Now, it takes less than a second. Greg Avedissian _______________________________________________ Rivendell-dev mailing list [email protected] http://caspian.paravelsystems.com/mailman/listinfo/rivendell-dev
