Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2001051

Re: [PHP-DB] PostgreSQL7.1: It's worth to upgrade. From: Anuradha Ratnaweera (anuradha <email protected>)
Date: 05/01/01

You have forgotton to mention new SQL features such as outer joins.
Postgres have been supporting many advanced sql features for a long time
those were not supported by other databases.

Anuradha

On Tue, 24 Apr 2001, Yasuo Ohgaki wrote:

> Hello PostgreSQL users,
>
> I'm testing PostgreSQL 7.1 and PHP4.0.4pl1 on Linux. It's really worth to
> upgrade.
>
> Besides PostgreSQL 7.1 supports any size of text, WAL, many bug fixes, better
> pg_dump/restore, etc. PostgreSQL 7.1 can provide more backends on the same box.
> A box, which could set to max 70 or less backends, can set upto 3000+ backends.
> The box would not be able to handle 3000 db connections, but it is really nice
> to have more db connections for web applications. 7.1 also seems much faster
> than 7.0.3. Text type with large data can consume a lot of CPU time. BLOB is
> suitable to store really large data.
>
> If you are using Windows, you are better to stay with 7.0. You will see error
> message with pg_errormessage() even if there is no errors. Wait or compile
> php_pgsql.dll with 7.1 libpq. (I don't have environment to compile it. If anyone
> has php_pgsql.dll with 7.1 libpq for PHP4.0.4pl1, could you tell where to get or
> send it to me?)
>
> --
> Yasuo Ohgaki
>
>
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>