Topic: how to stop it

[angel777]

hi is there a way to stop a select query while it is processing?
My user always felt annoying to wait for the loading process after they selected the wrong search filter combination.

 i am thinking to allow user to cancel the searching process if they do not want to continue.
any help will be greatful

[corbin]

Err...  You're searching queries shouldn't take that long...


And no, there's not a way to cancel a SELECT query....  Well, not gracefully.

[angel777]

hi, my query time actually is fine.
what i provides user is the 4 listbox which they are able to filter out the query as they want.
However, if user accidentally chooses the value like Select all from Site, select all from customers, select all from employees.. then nightmare comes.
how do i stop it ?

[fenway]

I don't see any sample queries, so I have no idea.

[Maq]

hi, my query time actually is fine.
what i provides user is the 4 listbox which they are able to filter out the query as they want.
However, if user accidentally chooses the value like Select all from Site, select all from customers, select all from employees.. then nightmare comes.
how do i stop it ?

It's your job to prevent that.  Why do you even allow such combinations?

[corbin]

Also, perhaps pagination should be used.

[Ken2k7]

There is KILL, but I don't know how to tie it into what you're doing. I agree with corbin. You may want to utilize pagination by selecting a limited amount of results per time.

[fenway]

Likewise... set a hard limit on the number of records to be returned, and you're set.