salesforce - Same SOQL Query taking a long time in a "VF page controller" VS in the "Developer Console" -

salesforce - Same SOQL Query taking a long time in a "VF page controller" VS in the "Developer Console" -

simple query, taking 1 min in vf page controller, , less 1 sec when executed in developer console. there more 50,000 records query searching through. why such dramatic difference in query run time?

string s = '123456'; list<registration__c> regs = [select id, name registration__c name =: s or speical_number__c =: s limit 1];

here excerpts debug logs:

developer console:

12:22:39.063 (63557000)|soql_execute_begin|[2]|aggregations:0|select id, name registration__c (name = :tmpvar1 or speical_number__c = :tmpvar2) limit 1

12:22:39.263 (263582000)|soql_execute_end|[2]|rows:0

vf page controller:

12:17:08.148 (3148592000)|soql_execute_begin|[633]|aggregations:0|select id, name registration__c (name = :tmpvar1 or speical_number__c = :tmpvar2) limit 1

12:18:07.350 (62350264000)|soql_execute_end|[633]|rows:0

i suspect has how vf/apex batch-up replies. although, limit 1 seem indicate not case. but, kicks ... seek ...

string s = '123456'; list<registration__c> regs = new list<registration__c>(); ( registration__c reg : [select id, name registration__c name =: s or speical_number__c =: s limit 1 ] ) { regs.add(reg); }

is speical_number__c candidate external id ? inquire because setting field external id guarantee salesforce.com create index field. without index, query total table scan.

salesforce visualforce soql