Exactly. That was my first guess - that his commandline request is first having to download 8M records which can take a long time. The OP's fear of "overhead from apache..." is not only unfounded, but would most definitely improve his response by simply running the query on the server and avoid the download. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php