[ic] big orders - slow performance - pgsql

Mike Heins mike at perusion.com
Wed Dec 3 17:23:55 EST 2003


Quoting Chen Naor (chen at lilux.co.il):
> Hello,
> 
> I have some performance problem while entering big orders 50 - 200 items with options.
> It seems to me that the INSERT command for the orderline is causing the problems.
> I know that in Postgres there an option to speedup this process by using the COPY command.
> Can someone help me out on this issue - it suppose to go to the log_transaction in some way.
> 
> Here is my configuration:
> 2 X P3-550Mhz 512MB RAM
> Fedora 1.0
> IC 4.9.9 (RPM)
> Perl 5.8.2 + Bundle::Interchange (from source)
> Postgresql 7.4
> 

I bet you don't have transactions enabled. Set TRANSACTION_TABLES
to "userdb orderline transactions inventory" in preferences.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.765.647.1295      <mike at perusion.com>

Fast, reliable, cheap.  Pick two and we'll talk.  -- unknown


More information about the interchange-users mailing list