c2c-oerpscenario team mailing list archive

[Dion Phillips <822303@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

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

** Affects: openobject-client-web
     Importance: Undecided
         Status: 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