Good Afternoon Michael:
Running a simulation of what your application is attempting to do:
mysql -N --user=genome --host=genome-mysql.cse.ucsc.edu -A \
-e "show tables;" hg18 | while read T
do
mysql -N --user=genome --host=genome-mysql.cse.ucsc.edu -A \
-e "desc ${T};" hg18
done
This takes about 2 minutes here in our local network environment,
producing output of about 45,306 description lines from the 4,593 tables.
Perhaps you can run the above loop in your environment and see
if it takes significant more time.
--Hiram
Michael Zouberakis wrote:
> No, I haven't used the -A switch. Actually retrieving all table names and
> fields is exactly what I need for my application.
>
> On Fri, Oct 30, 2009 at 7:02 PM, Galt Barber <[email protected]> wrote:
>
>> did you pass -A on mysql client cmdline to suppress loading all table names
>> etc feature?
_______________________________________________
Genome maillist - [email protected]
https://lists.soe.ucsc.edu/mailman/listinfo/genome
