As per typical Marketing, some major enhancements are being\n";
print "added to the fill text searching algorithms, stay tuned!\n";
}
else
{
# Start a timer, to time SQL operations
# FTSS has up to 10 timers
pg_FreeResult( pg_exec($conn, "select ftss_time_start(1)") );
# Format the SQL search call
$sql = "select webquery.*, ftss_key_rank(result.songid) as rank from webquery, ".
"(select ftss_direct('all { ".trim( $query)." }') as songid) as result ".
"where webquery.songid = result.songid order by ftss_key_rank(result.songid) desc";
# Show the search as an HTML comment
print "\n";
# Execute the FTSS call using the PostgreSQL FTSS functions
$res = pg_Exec( $conn, $sql );
if($res)
{
$count = pg_numrows($res);
if($count)
{
print "
\n";
print "\n";
print "| cdid | \n";
print "artist | \n";
print "title | \n";
print "song | \n";
print "trackid | \n";
print "rank | \n";
print "
\n";
for($i = 0; $i < $count; $i++)
{
$cdid = pg_Result($res,$i,"cdid");
print "\n";
print "| $cdid | \n";
print "". pg_Result($res,$i, "artist") . " | \n";
print "". pg_Result($res,$i, "title") . " | \n";
print "". pg_Result($res,$i, "song") . " | \n";
print "". pg_Result($res,$i, "songid") . " | \n";
print "". pg_Result($res,$i, "rank") . " | \n";
print "
\n";
}
pg_FreeResult($res);
print " \n";
#execute query
$res = pg_Exec($conn, $sql);
$ftsst = 0;
if($res)
{
$ftsst= pg_Result($res,0, "time");
print "
" . pg_Result($res,0, "count") ." total records " .
"(limited to " . pg_Result($res,0,"limit") . ") " .
$ftsst . " seconds in FTSS \n";
# Free up memory used by result
pg_FreeResult($res);
}
# Format and execute SQL to retrieve elapsed time, on timer 1
$res = pg_Exec($conn, "select ftss_time_elapsed(1) as \"elapsed\"" );
if($res)
{
$pgtime = pg_result($res,0,"elapsed");
print "
Total SQL Database time (PostgreSQL) time: ". ($pgtime - $ftsst) . " seconds\n";
print "
SQL Database time is not a product of FTSS ";
# Free up memory used by result
pg_FreeResult($res);
}
}
}
pg_Close($conn);
}
?>
The FreeDB Database search is an experimental service
under development. It is in no way to be considered
a commercial service. What you see here is code that is under
development. It is started and stopped at no predefined intervals,
and is frequently off-line.
Data presented here was obtained from the freedb CDDB alternative,
which can be located at www.freedb.org
Read about the FTSS Search System