Shawn,
if you want to try the indexes, they are table-based
so being on a shared MySQL server should that affect
your permissions to make indexes within your own
database...
--- Shawn Honeychurch <[EMAIL PROTECTED]>
wrote:
> 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]
>
>
__________________________________________________
Do You Yahoo!?
Yahoo! Photos - 35mm Quality Prints, Now Get 15 Free!
http://photos.yahoo.com/
------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Site: http://www.working-dogs.com/freetrade/
Problems?: [EMAIL PROTECTED]
