You could use the KTR database search table for a much faster query.
With regards to this line
|
$db_query = "SELECT infohash,name,size,uploaded,num_files FROM torrents WHERE LOWER(name) LIKE LOWER('%$query%')"; |
the db_query would become
"SELECT infohash,name,size,uploaded,num_files FROM torrents WHERE rowid IN (SELECT rowid FROM search WHERE name MATCH '%$query%')"
I hope this helps. It should improve query time by several orders of magnitude.
You could use the KTR database search table for a much faster query.
With regards to this line
trntSearch/provider/kiwi_torrent_research.php
Line 13 in dcc2dce
the db_query would become
"SELECT infohash,name,size,uploaded,num_files FROM torrents WHERE rowid IN (SELECT rowid FROM search WHERE name MATCH '%$query%')"
I hope this helps. It should improve query time by several orders of magnitude.