Select after applying the filter

Mario,
I'm not what is "run a select after applying the filter" and "query is blocked".

Could you rephrase your question?

Thank you very much for your response. I will explain better

I have the following query:
SELECT

LOCATIONID,

POSTEDTIME,

BUSINESSDATE,

JOBNAME,

MSGSIZE

FROM LOCATION_ACTIVITY_DB.TRANSACTION_KEY
The result is more than 14 million records. If this happens IE crashes or application fails.

What I need is that the user can apply the filter before running the query.

The user to first choose the LOCATIONID, BUSINESSDATE, JOBNAME and then to perform the query.

Turn on 'No records on first page' option that can be found on Miscellaneous screen in PHPRunner.

Thanks, but now this is my problem:

Fatal error: Maximum execution time of 60 seconds Exceeded in .. \output\include\dbconnection.php on line 29

You need to explain when this happens i.e. before search, after search, what are search parameters.
If you run a search and it times out you need to make sure all required indexes are in place etc. Especially important if you have millions of records.

When I set the query as follows:

SELECT

LOCATION,

POSTEDTIME,

BUSINESSDATE,

JOBNAMES,

MSGSIZE

FROM LOCATION_ACTIVITY_DB.TRANSACTION_KEY

WHERE (LOCATION = '6652')

The application works fine, bring the right results. But I can not see other LOCATIONID than the 6652 because it gives me no results.
Now, when you set the query as follows:

SELECT

LOCATION,

POSTEDTIME,

BUSINESSDATE,

JOBNAMES,

MSGSIZE

FROM LOCATION_ACTIVITY_DB.TRANSACTION_KEY

and use the filter to apply results do not come, giving the error.

I solved the problem by creating an index for the table.

Thank you very much for your help.