Re: PostgresQL or PHP bug?

Martijn van Oosterhout wrote:

>I don't see anything obvious but have a look at the rows it is
>considering duplicates. Are they the same list each time? By the way,
>it looks like you're connect()ing once for each query you are
>executing. You should only connect once at the beginning of the
>program.

Unfortunately I didn't check to see if it always outputted the same
items as being duplicates. I would think not but I'll try and check it out.

As for connect()ing once every query, I was under the impression that
PHP would only really connect() the first time, and on subsequent calls
to connect(), if the connect parameters are the same, would just return
the same backend connection.

The connection gets closed only (and automatically) once the PHP script
ends.

But that is only my *understanding* of PHP and connect() I might be
wrong on the implementation might be buggy (very possible).

I'll try connect()ing just once and also seeing if the duplicate items
are the same and report back.

Thanks for having a look, I really appreciate it!

Jc