c2c-oerpscenario team mailing list archive

[Dion Phillips <822303@xxxxxxxxxxxxxxxxxx>]

Hello Jignesh Rathod

I have just downloaded the latest development release of 6.1 from 
launchpad and this problem is still present. What I am trying to 
understand is whether this is expected behaviour or would this be 
regarded as a bug?

The biggest issue with this search is that once it has been started, 
there is no way to stop it. I have tried by closing the search window 
(by pressing the "x") but OpenERP just hangs for the same length of time 
before the user can proceed with anything.

Regards.

Dion Phillips
OpenLogic.com.au
0466 332 202


On 08/08/2011 08:45 PM, Jignesh Rathod(OpenERP) wrote:
> Hello Dion Philips ,
>
> Thank you for your suggestion! However this is unfortunately out of the scope of the current OpenERP release,
> so we cannot implement it in version 6.0.2.
> Because we already implemented in a new version 6.1 and it will release soon.If you needs this changes in current stable then you can contact us on support@xxxxxxxxxxx but you have a OPW contract with us.
>
>
> Thank you
>
> ** Changed in: openobject-client-web
>     Importance: Undecided =>  Wishlist
>
> ** Changed in: openobject-client-web
>         Status: New =>  Won't Fix
>

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