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 #178974 is a reply to message #178943]

Tue, 28 August 2012 16:33

houghi
Messages: 45
Registered: September 2011

Karma:

Member

Norman Peelman wrote:
> Ok, understandable that you are learning... :) Basically with your
> code you are asking the database for all the quote id(s) where the movie
> id is a match to your movie, and then saving it to an array ($result).
> Might as well grab all the data you're after while you're there the
> first time, which is what my code should do.

Clear. I will see what I can do to get the same results. Learning can be
fun. :-D

>> Thanks. phpMyAdmin tells me about quotes:
>> ~69,655 total, Query took 0.0003 sec
>>
>
> Is this after you created indexes on tconst and qconst? Without those
> indexes your times will get significantly worst as you db gets bigger.

After. See a reply to an other poster. Increase was (as expected) 100
times measured on the php page itself.

> Search for 'database normalization'.

Thanks.

houghi
--
This is written under the inluence of the following:
> Artist : Mercedes Sosa
> Song : Cuando ya me Empiece a Quedar Solo
> Album : Mercedes Sosa en Argentina

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: Mon Nov 25 23:56:05 GMT 2024

Total time taken to generate the page: 0.04236 seconds