#2 Slow response for viewing

[Loren]

I wonder if the code is still doing a license check?
Seems slow when accessing an item but not when opening from the component link.

[Matt]

Logged In: YES
user_id=1803502
Originator: NO

All the license check code is gone (unless you didn't upload a fresh /lib/core.php).

You mean a direct link into an item as the entry into the site versus browsing through the menu to get there?

[Loren]

Logged In: YES
user_id=1810455
Originator: YES

I just downloaded your zip file and my comparison program says the files match.
Strange that I have even had it time out on my local server (more than 30 seconds).
I have about 500 cars in my registry and it takes 20-30 seconds to view any car. Other tasks on this tester server are almost instantaneous.
See debug output PDF at: http://www.renntech.org/loren/slow_bug.pdf

[Loren]

Logged In: YES
user_id=1810455
Originator: YES

Sorry, forgot the second part these are from the Browse Registry list (generated by Main Menu, Browse, or Search).

[Matt]

Logged In: YES
user_id=1803502
Originator: NO

wow that is a long time, almost 20 seconds. If you set 'Show Modification Images in Gallery?' to no does the time to execute go down? And can you do an EXPLAIN on the 9th query down in that pdf.

-Matt

[Loren]

Logged In: YES
user_id=1810455
Originator: YES

Setting No to gallery images does not seem to make any difference. Even cars with no images take a long time.

Ah... interesting (see attached EXPLAIN SQL PDF).
I wonder if those two indexes are left over from my old Garage install?
I think I should try deleting those eh?

File Added: SQL result - phpMyAdmin 2.9.pdf

[Loren]

EXPLAIN on Query 9 SQL

[Matt]

Logged In: YES
user_id=1803502
Originator: NO

I guess those index names never got updated from the old days, that explain looks pretty good actually. Any chance you can send me your ibf_registry tables for testing?

[Loren]

Logged In: YES
user_id=1810455
Originator: YES

What email? gmail or acurainspired?

[Matt]

Logged In: YES
user_id=1803502
Originator: NO

gmail thnx.

[Loren]

Logged In: YES
user_id=1810455
Originator: YES

Sorry, this maybe a server problem on my end. I recently upgraded my PHP to 5.2.3 and now I notice that my old Registry version does the same hang delay.
I think I will try reverting back to my previous version of PHP and see if that fixes it.
I'll let you know...

[Loren]

Logged In: YES
user_id=1810455
Originator: YES

Okay the delay is much worse on PHP 5.2.3 than it is on PHP 5.2.1.
I've retested on my live site and my two staging servers -- 10-12 seconds seems to be the norm even without the license check.
Do you think this is a function of all those 52 SQL queries? and perhaps something is PHP5 is slowing the process?

[Matt]

Logged In: YES
user_id=1803502
Originator: NO

Good info to capture, we'll have to see what they changed with PHP 5.2.2/3 that could cause this. Indeed the view item page needs some work to get that sql count way down. The make/model lookup routines should probably be cached somehow.