GFF3 Loader very slow
Brought to you by:
sficklin
Hello.
I was loading a gff3 file, but the loadrig was very slow (100 lines/hour). I've already had loaded the Fasta files with the chromosomes sequences.
I saw that the query to retrieve the feature_id and uniquename in the gff_loader.php file (line 1042) is retrieving all attributes from feature table. As the feature table has the sequences of all chromosomes, the select was very slow. I changed the select query to retrieve only the attributes uniquename and feature_id and now the program is loading 40.000 lines/hour.
I think that this issue can be useful for many people.
Augusto