See below: ----------Original Message---------
> Hello Terry, > > Tuesday, March 9, 2004, 5:11:00 PM, you wrote: > > I know you have some solutions to the original problem already, but I > just wanted to make one small observation: > > TR> The fields are to be CounterCode (Varchar 10), CounterValue (Int > > 10) and > TR> CounterStartDateTime (DateTime). > > Using a varchar(10) for the CounterCode will give you a Dynamically > sized table. If you changed this to char(10) you will have the speed > benefits of a Fixed size table which MySQL will be able to process > significantly faster. This could be especially useful if this counter > is to be hit a lot of times (i.e. it's a popular site). > > -- > Best regards, > Richard Davey > http://www.phpcommunity.org/wiki/296.html Good point, Richard. I was perhaps in a little bit too much of a hurry putting that together, and didn't even consider that! Cheers Terry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]