Hello everyone,
Vacuum db doesn't help much - one on server it helps temporary on the other
not - so it is better solution add "order by" in your OE.pm module:
or you can apply patch OE.pm.diff:
---
321c321
< p.partnumber, p.assembly, o.description, o.qty, o.sellprice,
---
> o.oid, p.partnumber, p.assembly, o.description, o.qty,
o.sellprice,
325c325
< AND trans_id = $form->{id}|;
---
> AND trans_id = $form->{id} order by o.oid|;
---
After that changes all the items in stay in correct order.
Cheers,
Michael
On Tue, 09 Jul 2002 07:24, you wrote:
> Hello everyone,
> I think I solved the problem that was bugging me all day and took up quite
> some time of mine (and Dieter's. Thanks for the help).
>
> First we thought it was a version problem with the DBI and DBD-Pg modules
> for perl. I tried almost every possible combination :)
> At least I tried the newest versions and the ones from the SL FAQ. Didn't
> make a difference.
>
> After all the solution was quite simple: The database was in use for little
> over a year now and nobody ever thought of doing some maintenance work.
> After a vacuumdb it works just the way it should.
>
> So if you are not doing it already I would advice everyone to vacuum the SL
> database every once in a while. Speeds up the system to. I setup a cron job
> that will vacuum the database every night.
>
> Ciao,
>
> Philip
-------------------------------------------------------
This sf.net email is sponsored by:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
-------------------------------------------------------
(un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users
Archive: http://www.mail-archive.com/[email protected]/
