Thanks Leon;
That helps tons.
I guess if it is a shared MySQL server at a hosting company there is not
much I can tue.
My hosting company is still running PHP3, will I notice a speed increase
when they go to php4 do you think?
Shawn
----- Original Message -----
From: "Leon Atkinson" <[EMAIL PROTECTED]>
To: "FreeTrade" <[EMAIL PROTECTED]>
Sent: Wednesday, October 04, 2000 11:22 AM
Subject: RE: [FreeTrade] Question about optimizing PHP and empty cart
> > Does anyone know either a good program or tutorial to optimize
> > PHP code and
> > connections to MySQL? I love this cart but am finding it quite slow and
> > would like to speed it up abit.
>
> There aren't any major pain points in the PHP code that I know of. There
> are
> two things you can do to speed up MySQL. First, there really aren't
> adequate
> indexes on the tables. Take inspiration from the FreeTrade 2 build
script.
> The other thing is to tune MySQL itself. There's information in the MySQL
> documentation about how to do both of these things.
>
> > Also I do not like the blank "your cart is empty" screen, or the
> > blank"your
> > logged in" screen, where is the code I can change to change where the
> > customer goes in these situations. I would like them to go to the home
> > (welcome) page when logged in.
> > Any thoughts?
>
> There's two places to control what screen you go to. First, you can send
> the SCREEN variable in the form or link. Second, you could set $SCREEN
> inside your action module (in this case LOGIN_USER).
>
> Leon
>
>
>
> ------------------------------------------------------------
> To subscribe: [EMAIL PROTECTED]
> To unsubscribe: [EMAIL PROTECTED]
> Site: http://www.working-dogs.com/freetrade/
> Problems?: [EMAIL PROTECTED]
>
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
