Url shortener database Cache

So I am having problem with my site's performance so I consult my hosting what is the problem and they said this.

However, we see another 'slow' query, which

takes about a second

to complete and downloads the whole 'views' table

from the database for

some reason, with all the rows:

select * from views

It gets about half a million records, nearly every

second, and that

affects your site's performance negatively.

Also, it is

highly recommended to

use some caching in your script, and cache the

database query result,

rather than send the same 'slow' query frequently.


Using * is always a problem. Bcoz by using * you are actually giving MySQL work to find all tables first and then take the data. Instead of this best is .. If you want every table then better write SELECT rowname,rowname1,rowname2 FROM views

and I need to cache the database query result too

Habilidades: Administração de Bancos de Dados, Desenvolvimento de Banco de Dados

Veja mais:

Acerca do Empregador:
( 1 comentário ) balanga, Philippines

ID do Projeto: #10493289

3 freelancers estão ofertando em média $17 para esse trabalho


I have 5 + years of experience in MSBI Technology (SQL Server 2008/2012, SSIS, SSRS, and SSAS) Worked with the reputed clients like Microsoft, HCL, and Dicks Sporting Goods etc. Worked on various types of ER diagram Mais

$20 USD em 1 dia
(7 Comentários)

Hello, I am a linux security expert and do mysql optimizations as well. But please be aware of your developer. There is no issue with the *. I use * all the time but I think the issue is with query formation and op Mais

$20 USD em 1 dia
(0 Comentários)

Please check these. I think thats what you wanna do. [login to view URL]

$10 USD em 1 dia
(0 Comentários)