mariovaldez.net

MV.net forums
It is currently 14 Jul 2016, 00:56

All times are UTC - 7 hours




Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 8 posts ] 
Author Message
 Post subject: getting current currency
PostPosted: 30 Aug 2004, 11:01 
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


Report this post
Top
  
Reply with quote  
PostPosted: 04 Sep 2004, 05:46 
User avatar

Joined: 06 Mar 2003, 03:21
Posts: 447
Location: Monterrey, NL, Mexico
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).

:arrow: 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.


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: 05 Sep 2004, 11:35 
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


Report this post
Top
  
Reply with quote  
 Post subject: Rendering time...
PostPosted: 05 Sep 2004, 11:47 
User avatar

Joined: 06 Mar 2003, 03:21
Posts: 447
Location: Monterrey, NL, Mexico
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.


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: 07 Sep 2004, 07:10 
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


Report this post
Top
  
Reply with quote  
PostPosted: 07 Sep 2004, 08:42 
User avatar

Joined: 06 Mar 2003, 03:21
Posts: 447
Location: Monterrey, NL, Mexico
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.


Report this post
Top
 Profile  
Reply with quote  
 Post subject: No solution...
PostPosted: 07 Sep 2004, 23:25 
User avatar

Joined: 06 Mar 2003, 03:21
Posts: 447
Location: Monterrey, NL, Mexico
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.


Report this post
Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: 09 Sep 2004, 05:49 
thx and yes you are right we have 1600 Cats

regards


Report this post
Top
  
Reply with quote  
Display posts from previous:  Sort by  
Forum locked This topic is locked, you cannot edit posts or make further replies.  [ 8 posts ] 

All times are UTC - 7 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group