[PHP-DB] Re: major performance disparities with mysql/php - SOLVED

2002-03-21 Thread Henry Hank
Nevermind.. I found the problem. My production server is running mysql 3.22.29, and I needed to use a SET SQL_BIG_TABLES=1 in many places to prevent a "full table" condition. The new server is running 3.23, and once I removed the SQL_BIG_TABLES=1 from the script (and allowed mysql to use memor

[PHP-DB] major performance disparities with mysql/php

2002-03-20 Thread Henry Hank
Hello - I'm posted this to the mysql list but got no response. While it sounds like a mysql problem, I'm convinced that it is a PHP problem (see bottom of note.) I've recently installed mySQL on a RH7.2 box without any problems - it runs great. I've been testing some long running queries (fu

[PHP-DB] Determine last quarter

2002-03-20 Thread Henry Hank
> If anyone is interested, this is what I finally came up with. I'm not sure > how graceful it is, but it works ;) Here's another method... which can be condensed, but I left it expanded to demonstrate what was going on. The trick is finding the first day of the *next* month, and getting the p