RE: Lost Data #2

2002-01-29 Thread Matthew Walker
29, 2002 5:45 PM To: Matthew Walker; Scott Wang; [EMAIL PROTECTED] Subject: Re: Lost Data #2 If I run optimize on the table once - will I have to come back and so it again? If so - how often? Thanks Mark -Original Message- From: Matthew Walker <[EMAIL PROTECTED]> To: Mark Str

Re: Lost Data #2

2002-01-29 Thread Mark Stringham
MAIL PROTECTED]> Date: Tuesday, January 29, 2002 4:18 PM Subject: RE: Lost Data #2 >To get rid of overhead, run an OPTIMIZE TABLE on the table. > >Matthew Walker >Ecommerce Project Manager >Mountain Top Herbs > > >-Original Message- >From: Mark Stringham [m

RE: Lost Data #2

2002-01-29 Thread Matthew Walker
To get rid of overhead, run an OPTIMIZE TABLE on the table. Matthew Walker Ecommerce Project Manager Mountain Top Herbs -Original Message- From: Mark Stringham [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 29, 2002 11:02 AM To: Scott Wang; [EMAIL PROTECTED] Subject: Re: Lost Data

Re: Lost Data #2

2002-01-29 Thread Mark Stringham
Scott - I recently had a similar problem with a JSP application I built using MySQL on the backend. Don't know what the issue is/was but I did notice that if I was updating rows in a table on a regular basis - PHPmyAdmin 2.2 says I have a lot of "overhead" in the table. I'm not sure what is causi