Hello Dion phillip, I have checked your issue and found that you download a trunk web, server, addons which is under development so might be its not properly working.You have to wait up till the version release.
Thanks. -- You received this bug notification because you are a member of C2C OERPScenario, which is subscribed to the OpenERP Project Group. https://bugs.launchpad.net/bugs/822303 Title: "Sales Order Lines" - Long delay for product search with large product database Status in OpenERP Web Client: Won't Fix Bug description: I have a products database of 10,000+ products and when I put a single character ("a" for example) into the "Product" field of the "Sales Order Lines" form and press tab, the web client can take up to 1 minute to return a result set. I have look at the SQL being executed against Ppostgres and if the result set is 7000 rows, the server will do 4 sql statements of +- 7000 calls each (i.e 28,000 sql queries) I have also notice that if I do the same search a second time for the same character, the query is much quicker - almost instant. This does however not apply to the character "b" which always takes a minute for a result even though it is returning less rows that the letter "a". Also, if I change the case of the character (from "a" to "A"), the search will them again take 1 minute to return a result. If I use the GTK client. results are always almost instantaneous. I can switch between upper and lower case characters without any reduction in performance. I don't know if this is due to the GTK restriction of 100 rows and thus the server is only ever fetching 100 rows. Hopefully this is a bug or design flaw which can be fixed as it will seriously effect the end user experience and the perception of the OpenERP product and its usability and speed. OpenERP server & client version - 6.0.2 Ubuntu 10.04 Postgres 8.4 To manage notifications about this bug go to: https://bugs.launchpad.net/openobject-client-web/+bug/822303/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~c2c-oerpscenario Post to : [email protected] Unsubscribe : https://launchpad.net/~c2c-oerpscenario More help : https://help.launchpad.net/ListHelp
