PHP views field have performance issue when query large nodes

Updated: Comment #3

Problem/Motivation

We have 100k nodes, just create a views, simply add these critaria:

• field:title
• field:global php field: in output textarea enter print 123;
• filter:true

Then the query execution time will from 100ms increase to 8000ms.

The version I use:

views_php

version = "7.x-1.x-dev"
core = "7.x"
project = "views_php"
datestamp = "1329828512

views

version = "7.x-3.5"
core = "7.x"
project = "views"
datestamp = "1345829394"

Proposed resolution

1. After some search, I just place a return in the function query of views_php_handler_field.inc, then the query execution time back to normal.
And the result still correct. I'm not sure the reason of performance issue.
2. The patch proposed in #1937364: Filter does not respect pagination, it runs through all nodes in a search

Remaining tasks

See if the proposed patch applies to this issue and test it.