Re: [PHP-DB] debugging pg_connect
I suspect that PostgreSQL would log anything related to a network connection problem if the error logging level was set correctly. If you don't see any of those perhaps it is a networking issue. You might need to try an ethernet capture tool like Wireshark or perhaps something like tcpflow. John On Apr 26, 2007, at 4:26 AM, [EMAIL PROTECTED] wrote: Hello, since we upgraded to the latest php and PostgreSQL - we started to get frequent pg_connect() errors. What is sure is that they are not caused by insufficient connections - PostgreSQL reports 100 connections available and less than 10 used when the pg_connect fails. pg_last_error() and the other error handling functions operate on connection. So they do not seem useful when pg_connect() fails. In the PostgreSQL documentation I could find out how to log successful connections, but not how to login failed connections. Could somebody advice me on possible ways to test? John DeSoi, Ph.D. http://pgedit.com/ Power Tools for PostgreSQL -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] 20K photos
Hi all, Imagine that you want to put some 2 historical photos On display in your website , you use PHP and MySQL. Preparing a photo album with 200 photos is no problem but for 2 photos! would you do it in the same way? Please comment. - Ahhh...imagining that irresistible new car smell? Check outnew cars at Yahoo! Autos.
Re: [PHP-DB] 20K photos
Sorry but I don't see where the problem would be. Aleksander Quoting elk dolk [EMAIL PROTECTED]: Hi all, Imagine that you want to put some 2 historical photos On display in your website , you use PHP and MySQL. Preparing a photo album with 200 photos is no problem but for 2 photos! would you do it in the same way? Please comment. - Ahhh...imagining that irresistible new car smell? Check outnew cars at Yahoo! Autos. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] 20K photos
Hi Imagine that you want to put some 2 historical photos On display in your website , you use PHP and MySQL. Preparing a photo album with 200 photos is no problem but for 2 photos! would you do it in the same way? Yes, but I don't necessarily see the need for a db. If you have additional information on the pictures to store, then yes, use a db. Otherwise all the info you need is available from the files. For small numbers I wouldn't store the filenames in the db. For 20K, I would. Decide on how many images per page, then use SELECT with LIMIT to pull out a page's worth of files and show the page. Back/Next tell the page what offset to use for the LIMIT clause. Niel -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php