I'm accessing a view table with 6 million lines from a oracle database using the ADOdb for PHP library. running the following SQL query from a web server in a SUSE machine takes about 1 min:\[quote\] $adodb_handle->Execute("SELECT COUNT(BEPROTEXT) FROM (SELECT BEPROTEXT FROM V_E_LOG WHERE BEPROTEXT LIKE '%jaya%' )");\[/quote\]running the same SQL query from wamp on my laptop (also using ADOdb lib) takes about 7 secif i run the following SQL query:\[quote\] $adodb_handle->Execute("SELECT COUNT(BEPROTEXT) FROM V_E_LOG");\[/quote\]it takes about 3 sec from both SUSE and laptop.I have no idea why the first query from the SUSE machine takes so long, 1min?Could you guys give me some advice on how can i solve this or debug the problem out? I'm at a dead end here 