I would like to run queries against the genome-mysql.cse.ucsc.edu database which may be excessive and don't want to cause problems for others.
I want to find matches for a particular chromosome which have the same name and observation for tables hapmapSnpsCEU, haphapmapSnpsYRI, mapSnpsCHB, hapmapSnpsJPT. Doing a query to pickup the count of hapmapSnpsCEU for one chromosome took 0.14 seconds. If I do a query to pick up the count joining hapmapSnpsCEU and hapmapSnpCHB took 8.40 seconds. If I join all tables would that constitute an excessive load? Below is the query joining two tables. ====== select count(*) from hapmapSnpsCEU, hapmapSnpsCHB where hapmapSnpsCEU.chrom = 'Chr16' and hapmapSnpsCHB.chrom = 'Chr16' and hapmapSnpsCEU.name = hapmapSnpsCHB.name and hapmapSnpsCEU.observed = hapmapSnpsCHB.observed; ====== johnh... _______________________________________________ Genome maillist - [email protected] https://lists.soe.ucsc.edu/mailman/listinfo/genome
