in reply to Perl DBI Performance

See Re: A more elegant solution? and consider doing the same sort of thing for your insert AND update statements. All that preparing without placeholders is probably killing your performance.

Replies are listed 'Best First'.
Re: Re: Perl DBI Performance
by Evanovich (Scribe) on Aug 18, 2001 at 04:43 UTC
    Right. Forgot to say: Postgresql doesn't support placeholders on tables. I don't think. Someone correct me if I'm wrong.
[reply]
      Placeholders are emulated by the DBD::pg module. Check out the docs. I don't know if that'll solve your speed problems, but your table really isn't that big. I don't have experience with PostgreSQL, but I've done multiple updates on 500,000 row tables in mySQL and it's only taken about 10 minutes on decent hardware.

      Your poor performance may also be a function of the excessive amount of cols in your table. Maybe you should consider redesigning your database to use multiple tables and foreign keys. That might make things better.

      Gary Blackburn
      Trained Killer

[reply]

In Section Seekers of Perl Wisdom