← Back to team overview

c2c-oerpscenario team mailing list archive

[Bug 822303] Re: "Sales Order Lines" - Long delay for product search with large product database

 

** Changed in: openobject-client-web
   Importance: Wishlist => Undecided

** Changed in: openobject-client-web
       Status: Won't Fix => New

-- 
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:
  New

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


References