>
>Umm... Asking a non-perl question on a perl mailing list?
Well, I am using perl to ACCESS the database, does that help? Sorry,
but I belong to several mailing lists already and this (OSX) seemed
the most appropriate. Figured that someone here using perl and using
OSX might also be using MySQL on the OSX system and thus...
>
>But I'd guess that the terminal might not be 'freezing up', it's
>just taking MySQL a long time to create the table... You could try
>opening up a separate terminal window, and doing a top or ps to see
>what's going on, or use Process Viewer for the GUI-minded....
I've glanced but not looked extensively. I'm trying your suggestion
as I write but it appears that something is locked up as 'top' is no
longer reporting (i.e. the numbers are not changing). I'll wait
awhile, but that seems odd. Process Viewer is reporting but I'm not
sure how to read it - shows the status for Terminal, mysql and mysqld
as "Running" but each is using 0% of the CPU.
>You could try creating the table with a subset of the 120+ fields,
>and then using ALTER TABLE (or the mySQL equiv..) to add fields in
>chunks.
>
>Or double-check the documentation for MySQL to see if somehow it has
>a limit on the number of fields in a table...
>
No reference to number of fields limit in MySQL that I could find -
just an overall table size (order of 4 Gb). I did try breaking it
down into smaller chunks (copying and pasting), but may have to use
ALTER as you suggest.
--
===========================================================
Nelson Goforth Lighting for Moving Pictures
phone: 01.303.322.5042 pager: 01.303.634.9733
resume: http://www.earthnet.net/~ngoforth/film
