On Jan 2, 2006, at 5:34 PM, SunWuKung wrote:
What do you suggest is the most effective way to insert this type of
data into the db? Issuing multiple inserts from php seems to be a
waste
of resources.
I was thinking of writing the responses into a pg array field with a
single insert and than explode the content of that field into rows
with
a function.
This may help. But other than using some form of COPY, you'll
probably get the best performance increase using prepared statements.
Unfortunately, I think this is only available in PHP 5.1 and later.
John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
