Comment 14 for bug 770243

Hello Olivier,

I assume you are talking about the postgres sequence module that Sharoon Thomas has developed? As you have stated there are actually two issues with the sequences, one of which has been addressed by that module.
@ Sinoj, there is already a bug report and proposed solution to that issue here
https://bugs.launchpad.net/openobject-server/+bug/746620

This stock management problem is very interesting.

I have a question though, How can OpenERP ever support the possibility of 1,000s of stock locations with the stock_move database structure. Some consultants have said that every time it tries to compute the stock with that many locations the system will become slower and slower and in 6 months with that many locations it will be unusable. This is because of the function field and it has to compute all of the moves to correctly calculate the value of stock. We too have this problem with multiple stock locations. We have between 1,500-2000 and we have maybe even 1,000 stock moves per day.

Our servers are 2x Quad Xeon and 16GB Memory with separated database server and application server (physical) It takes up to 10 minutes to validate picking on some orders. Will try the patch