mySQL copy table performance issue?

[Jonathan Jiang]

Hey everybody,

New to the forum, not new to asp and oracle, but very new to mySQL and php. The more I work with mySQL the more I love it.

I run a HP-Unix box back at home with HP UX OS

One issue that has struck me as odd occurs when:

create table xtable as select * from ytable

And then simply listing them right after creation causes xtable to read _slower_ by .0002 seconds than original ytable.

Now these tables each have only a mere 214 rows, can someone assure me that this .0002 seconds won't blow up in my face when I add much more, say, 1 or 2 millon rows?

Note: everything in the basic table has a VARCHAR[50], with the exclusion of one varchar[255]. no blobs, none of the really big stuff.

thanks a lot guys!

John
limxdul at gmail dot com