print "Creating ClinSig index..." sys.stdout.flush() idxStart = time.time() cursor.execute(clinIndex) postgresConnection.commit() idxEnd = time.time() result.idxClinSig = idxEnd - idxStart print "Creating Gene index..." sys.stdout.flush() idxStart = time.time() cursor.execute(geneIndex) postgresConnection.commit() idxEnd = time.time() result.idxGene = idxEnd - idxStart resultsFile.write(result.toString() + '\n') # Run queries if requested in args if runQueries: for z in range(1,11): result = Result() result.method = "pgsql-Qry" + str(z) result.tag = tag print "Running queries, count " + str(z) idxStart = time.time() cursor.execute("SELECT * FROM locus l, snp s WHERE l.snp_id = s.id AND s.rsid = 'rs8788'") idxEnd = time.time() result.qryByRsid = idxEnd - idxStart