RE: [PHP-DB] Mysql completing Query fast but mysql-query() takes long time to return even single selects/updates

2010-04-12 Thread David Murphy
I see this occurring randomly on different quries with different indexes/tables. It appears like php is taking a lot longer than mysql's transmission time to cache the result be it bool TRUE/FALSE ora select of 1 - 50 records. While it does not happen all the time, since from the MySQL

[PHP-DB] Postgres - how to skip 'sequence' columns

2010-04-12 Thread Gary .
Is it possible to skip column(s) in the target table when using pg_copy_from? When I tried to bulk insert some data from a csv file by way of pg_copy_from I received the error Warning: pg_copy_from() [function.pg-copy-from]: Copy command failed: ERROR: permission denied for relation xyz, pretty

Re: [PHP-DB] Postgres - how to skip 'sequence' columns

2010-04-12 Thread Chris
Gary . wrote: Is it possible to skip column(s) in the target table when using pg_copy_from? When I tried to bulk insert some data from a csv file by way of pg_copy_from I received the error Warning: pg_copy_from() [function.pg-copy-from]: Copy command failed: ERROR: permission denied for