FUDforum: comp.lang.php » Speeding up of php page

Home » Imported messages » comp.lang.php » Speeding up of php page

Show: Today's Messages :: Polls :: Message Navigator

Re: Speeding up of php page [message #178926 is a reply to message #178925]

Sun, 26 August 2012 10:37

The Natural Philosoph
Messages: 993
Registered: September 2010

Karma:

Senior Member

houghi wrote:
> I have a page that takes 7.4 seconds to load. I believe this is due to
> the bad way it asks for the MySQL data.
>
> I have moved the MySQL database from HD to SSD and even to memory, but
> there was no significant increase in speed. This makes me believe it is
> the way I (badly) wrote the queries and/or the building of the page.

> $sql = "SELECT qconst FROM quotes WHERE tconst LIKE \"$tconst\" GROUP BY qconst";

Add an index on tconst

should give you about 100:1 speed up

--
Ineptocracy

(in-ep-toc’-ra-cy) – a system of government where the least capable to
lead are elected by the least capable of producing, and where the
members of society least likely to sustain themselves or succeed, are
rewarded with goods and services paid for by the confiscated wealth of a
diminishing number of producers.

Report message to a moderator

[Message index]

		Speeding up of php page By: houghi on Sun, 26 August 2012 10:15
		Re: Speeding up of php page By: The Natural Philosoph on Sun, 26 August 2012 10:37
		Re: Speeding up of php page By: houghi on Sun, 26 August 2012 11:43
		Re: Speeding up of php page By: Norman Peelman on Sun, 26 August 2012 13:24
		Re: Speeding up of php page By: houghi on Sun, 26 August 2012 17:34
		Re: Speeding up of php page By: Norman Peelman on Sun, 26 August 2012 22:43
		Re: Speeding up of php page By: houghi on Tue, 28 August 2012 16:33

Previous Topic:	Database Abstraction Layer
Next Topic:	Using SQLite3 on 1&1 or elsewhere that does not have it installed

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 08:20:40 GMT 2024

Total time taken to generate the page: 0.06174 seconds