Urgent: Site takes higher loading time.....

Status
Not open for further replies.
M

macmillan

Hi........

I am a beginner. I have developed website in Php/MySql. But my home page takes some more time to load in some of the browsers

Check this http://www.direct2deal.com

Can Mysql stored procedures help me? I don't know the concepts of stored procedures. If any buddy in group knows
pl. help me


Its very urgent. Your feedback/suggestions will be highly appreciated.
 
C

clau

Site takes higher loading time

Hi macmillan,

I don't think that stored procedures will help you much. The high loading time is not a MySQL fault. the loading time is influenced by the type of data you are loading. If that data is picture than, normaly, the time it takest to load is higher than if the data is text.

A stored procedure is a set of SQL commands that can be compiled and stored in the server. Once this has been done, clients don't need to keep reissuing the entire query but can refer to the stored procedure. This provides better performance because the query has to be parsed only once, and less information needs to be sent between the server and the client. You can also raise the conceptual level by having libraries of functions in the server.

I hope that helps,

Clau
 
Status
Not open for further replies.
Top