From: Sofia R. <so...@ne...> - 2006-12-26 04:44:00
|
Hi Scott, What is the best way to dump data from chado and then load into mysql? I have played around a little with this and am having problems with gff versions. i can dump out gff3 and i have the gff3 that i started with originally, but so far the only tool i can find to bulk load into mysql is bp_load_gff.pl. I am finding that this script needs gff2 (i think gff2; the one that does not have Tag=Value pair format in the ninth column). the reason i want to play with mysql is to see if i can improve on the speed of gbrowse queries. the chado/gbrowse queries take FOREVER, if they work at all, due to time out issues. is there something that i can do with postgres or my data to make the queries run in a reasonable amount of time in chado/gbrowse? or should i continue in trying to port my data to mysql? thanks sofia |