#3147 – Slow Update Query

Hi

I don't see how this would make any measurable difference. Have a look at the EXPLAIN section, and you'll see the query is fully indexed and optimized by MySQL:



1 - What are your full and exact Joomla and sh404SEF versions?
2 - Is this on a real life server or on localhost machine? (on my local test machine, this queries uses 1.79ms)
3 - How does it compare to other write instructions happening on the same page?
4 - You can always try to make the var an int, I would suggest the following:

- Open /administrator/components/com_sh404sef/classes/router.php
- at line 1304, replace:

ShlDbHelper::update('#__sh404sef_urls', array('cpt' => $hits, 'last_hit' => ShlSystem_Date::getUTCNow()), array('id' => $lookUp->urlRecord->id, 'rank' => 0));

with

ShlDbHelper::update('#__sh404sef_urls', array('cpt' => $hits, 'last_hit' => ShlSystem_Date::getUTCNow()), array('id' => (int) $lookUp->urlRecord->id, 'rank' => 0));

As an alternative version, you can also use instead:

ShlDbHelper::update('#__sh404sef_urls', array('cpt' => $hits, 'last_hit' => ShlSystem_Date::getUTCNow()), array('id' => (int) $lookUp->urlRecord->id));

In all cases, I'd rather suggest you check and optimize your sh404sef_urls database table, it may be damaged or corrupted, or in need of optimization.

Rgds

Hi

Can you please show me link / page to follow optimisation of sh404sef table?

I was not talking about anything regarding sh404SEF, but simply MYSQL database table optimization, ie server maintenance. This can be achieved with PHPMYAdmin or similar, or maybe your hosting control panel, if your hosting company offers one. If not, then the best people to talk to are the hosting company indeed.

Rgds