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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]