[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