mariovaldez.net

Hi Mario,

i don´t know if this is really a bug, but if i start the application it takes a long time for getting the current currency.
The query of the Cats and Prods are really fast.

regards

Jan

Jan:

> Hi Mario, i don´t know if this is really a bug, but
> if i start the application it takes a long time for
> getting the current currency. The query of the
> Cats and Prods are really fast.

Please download the latest version (at this time 0.1.0.407) and enable "SQL queries logging" in the Configuration window (in the first tab). That will create a log file named "OSCDEBUG.TXT" in the directory of the application.

That file contains the log of all SQL queries with a timestamp. For example:

2004-09-04 07:38:27:574|Executing query of type 0: select languages_id, name from prefix2_langs order by name
2004-09-04 07:38:27:574|Ready... set...
2004-09-04 07:38:27:574|Go!
2004-09-04 07:38:27:644|Done!

In that example, the time between "Go" and "Done" is the query time; around 70 milliseconds. Check all the query times of the start (when tax classes, languages, categories, currencies and manufacturers are loaded).

I could be that the problem is not the query but the rendering of the category tree (which is known to be slow with too many categories).

Please let me know what you find, Jan.

Regards,

Mario A. Valdez-Ramirez.

you are right

2004-09-05 20:33:23:000|Executing query of type 0: select languages_id, name from languages order by name
2004-09-05 20:33:23:000|Ready... set...
2004-09-05 20:33:23:000|Go!
2004-09-05 20:33:23:187|Done!
2004-09-05 20:33:23:187|Executing query of type 0: select categories.categories_id, categories.parent_id, categories_description.categories_name from categories, categories_description where categories_description.categories_id= categories.categories_id and language_id=2 ORDER BY categories_description.categories_name
2004-09-05 20:33:23:468|Ready... set...
2004-09-05 20:33:23:484|Go!
2004-09-05 20:33:24:109|Done!
2004-09-05 20:33:24:375|Executing query of type 0: select manufacturers_id, manufacturers_name from manufacturers order by manufacturers_name
2004-09-05 20:33:24:375|Ready... set...
2004-09-05 20:33:24:375|Go!
2004-09-05 20:33:24:515|Done!
2004-09-05 20:33:24:531|Executing query of type 0: select tax_class_id, tax_class_title from tax_class order by tax_class_title
2004-09-05 20:33:24:531|Ready... set...
2004-09-05 20:33:24:531|Go!
2004-09-05 20:33:24:687|Done!
2004-09-05 20:33:24:687|Executing query of type 0: select currencies.code, currencies.symbol_left, currencies.symbol_right from currencies, configuration where configuration.configuration_key="DEFAULT_CURRENCY" and configuration.configuration_value=currencies.code
2004-09-05 20:33:24:687|Ready... set...
2004-09-05 20:33:24:687|Go!
2004-09-05 20:33:24:906|Done!

it has something to do with the rendering, so everything is fine, i can live with this.

All i can say "Great Application"

regards

Jan

Jan:

> it has something to do with the rendering,
> so everything is fine, i can live with this.

Hello. Tell me, how many seconds does it takes to render the category tree? Also, are you connected to the store in a LAN or through the Internet? And finally, how many categories do you have in your store?

I want to replicate your problem, maybe I can improve the response time.


Regards,

Mario A. Valdez-Ramirez.

Hello Mario,

sorry for the slow response but we have an exchange server outage today ;(
To your questions
i am working over a adsl connection (768 kbit down/128 kbit up) and i have 16001 Categorys at all at the moment (still growing).
The timeout for rendering the categorys are about 5-10 seconds at all.

regards

Jan

Jan:

> i am working over a adsl connection
> (768 kbit down/128 kbit up) and i have
> 16001 Categorys at all at the moment
> (still growing). The timeout for rendering
> the categorys are about 5-10 seconds at all.

Thanks for the information. I think you mean "1600" categories (16000 would cause an error).

I will try to replicate that and see if I can improve the response time. (I think the cause is the rendering speed, but it can also be the downloading speed, although 1600 categories are around 64K of data plus some protocol overhead).

Regards,

Mario A. Valdez-Ramirez.

Jan:

I have tried lot of optimizations. My conclusion (and the conclusion of a lot of developers) is that the native TreeView control of Windows is sloooooow.

Anyway, I'm still thinking if I should use a better control. The best I found (which other developers say is pretty fast) is Virtual TreeView.

However, I was thinking on someday to port the OSCPMWin application to Kylix, and Virtual TreeView is not really Kylix-safe.

I'm still thinking about this. I'll let you know.


Regards,

Mario A. Valdez-Ramirez.

thx and yes you are right we have 1600 Cats

regards