Catalog component loading Very slow on trunk

[Ganesh B]

Hi,

The catalog component in back-end loading very slow, Its taking almost 10-12 secs to load the page.

After looking in details I found that its because of the 'Search Products' left bar screen.

There are below ajax request called on every page load and are taking more time. 

1. https://demo-trunk.ofbiz.apache.org:8443/catalog/control/LookupProductCategory (Its called 6 times for every page load )

2. https://demo-trunk.ofbiz.apache.org:8443/catalog/control/LookupProduct (its called 4 times for every page load)

Can we avoid those request to call on page load.

As they are for auto lookup, we need to fire those request when someone really try to search product/category. 

May be onFocus event on category and product search text box.

I have attached the screen shot to see multiple ajax calls with there load time.

--
Thanks,
Ganesh Bawne
Enterprise Software Developer
Viithiisys Pvt. Ltd.
http://www.viithiisys.com

[Jacques Le Roux]

Indeed, at 1st glance it seems there is something wrong (doubled lookups requests), I will have a closer look...

Else it's not that long here. A second to load the whole page on a simple dev machine. Which type of setting are you using (machine, network, DBMS, etc.)?

Jacques
  ----- Original Message -----
  From: Ganesh Bawne
  To: [hidden email]
  Sent: Monday, June 27, 2011 6:54 AM
  Subject: Catalog component loading Very slow on trunk


  Hi,


  The catalog component in back-end loading very slow, Its taking almost 10-12 secs to load the page.
  After looking in details I found that its because of the 'Search Products' left bar screen.


  There are below ajax request called on every page load and are taking more time.
  1. https://demo-trunk.ofbiz.apache.org:8443/catalog/control/LookupProductCategory (Its called 6 times for every page load )
  2. https://demo-trunk.ofbiz.apache.org:8443/catalog/control/LookupProduct (its called 4 times for every page load)


  Can we avoid those request to call on page load.
  As they are for auto lookup, we need to fire those request when someone really try to search product/category.
  May be onFocus event on category and product search text box.




  I have attached the screen shot to see multiple ajax calls with there load time.






  --
  Thanks,
  Ganesh Bawne
  Enterprise Software Developer
  Viithiisys Pvt. Ltd.
  http://www.viithiisys.com

[Ganesh B]

Thanks you Jacques,

Its strange,  I checked the issue on other server m/c and is also taking
around 7-8 secs.

My machine details are as follows:
Processor : Intel Core 2 Due CPU T9400@2.53 GHz
RAM : 3 GB
DB - Postgres 9.0


Thanks,
Ganesh


On Mon, Jun 27, 2011 at 5:16 PM, Jacques Le Roux <
[hidden email]> wrote:

> Indeed, at 1st glance it seems there is something wrong (doubled lookups
> requests), I will have a closer look...
>
> Else it's not that long here. A second to load the whole page on a simple
> dev machine. Which type of setting are you using (machine, network, DBMS,
> etc.)?
>
> Jacques
>   ----- Original Message -----
>  From: Ganesh Bawne
>  To: [hidden email]
>  Sent: Monday, June 27, 2011 6:54 AM
>  Subject: Catalog component loading Very slow on trunk
>
>
>  Hi,
>
>
>  The catalog component in back-end loading very slow, Its taking almost
> 10-12 secs to load the page.
>  After looking in details I found that its because of the 'Search Products'
> left bar screen.
>
>
>  There are below ajax request called on every page load and are taking more
> time.
>  1.
> https://demo-trunk.ofbiz.apache.org:8443/catalog/control/LookupProductCategory(Its called 6 times for every page load )
>  2. https://demo-trunk.ofbiz.apache.org:8443/catalog/control/LookupProduct(its called 4 times for every page load)
>
>
>  Can we avoid those request to call on page load.
>  As they are for auto lookup, we need to fire those request when someone
> really try to search product/category.
>  May be onFocus event on category and product search text box.
>
>
>
>
>  I have attached the screen shot to see multiple ajax calls with there load
> time.
>
>
>
>
>
>
>  --
>  Thanks,
>  Ganesh Bawne
>  Enterprise Software Developer
>  Viithiisys Pvt. Ltd.
>  http://www.viithiisys.com
>

--
Thanks & Regards
Ganesh Bawne
Enterprise Software Developer
Viithiisys Pvt. Ltd.
http://www.viithiisys.com

[Ganesh B]

Hi Guys,

Does anyone faced similar issue?


Thanks,
Ganesh

On Mon, Jun 27, 2011 at 10:24 AM, Ganesh Bawne <[hidden email]>wrote:

> Hi,
>
> The catalog component in back-end loading very slow, Its taking almost
> 10-12 secs to load the page.
> After looking in details I found that its because of the 'Search Products'
> left bar screen.
>
> There are below ajax request called on every page load and are taking more
> time.
> 1.
> https://demo-trunk.ofbiz.apache.org:8443/catalog/control/LookupProductCategory(Its called 6 times for every page load )
> 2. https://demo-trunk.ofbiz.apache.org:8443/catalog/control/LookupProduct(its called 4 times for every page load)
>
> Can we avoid those request to call on page load.
> As they are for auto lookup, we need to fire those request when someone
> really try to search product/category.
> May be onFocus event on category and product search text box.
>
>
> I have attached the screen shot to see multiple ajax calls with there load
> time.
>
>
>
>
> --
> Thanks,
> Ganesh Bawne
> Enterprise Software Developer
> Viithiisys Pvt. Ltd.
> http://www.viithiisys.com
>