3 messages in com.mysql.lists.mysqlRe: general question| From | Sent On | Attachments |
|---|---|---|
| Octavian Rasnita | 28 Jul 2005 11:17 | |
| SGr...@unimin.com | 28 Jul 2005 11:47 | |
| Ronan Lucio | 28 Jul 2005 12:10 |
| Subject: | Re: general question |
|---|---|
| From: | Ronan Lucio (ron...@videosoft.com.br) |
| Date: | 07/28/2005 12:10:56 PM |
| List: | com.mysql.lists.mysql |
Octavian,
I am using a MySQL database on a web site, and I would like to know what happends if someone searches in the database using a form, but after a few seconds MySQL starts the query, that user hit the "Stop" button of the browser. Will MySQL continue its searching and also create the cache, or it will stop automaticly?
Interactivity between the webserver and the database is server-side. So, when the user clicks on the stop button, it should simply ignore the response client-side.
In other words: The server will complete his job and send you the result but your browser will ignore it.
It´s just my thoughts. I´m not sure about it, but the logic is this.
If it will also stop, can I do something to let it continue searching in order to create the cache and the next time another visitor searches for the same thing it will get the results from the cache?
If you use query cache in server side (on database or on your programing language), yes. It should works.
If you use cache base on proxy or in the client browser. Once the result was ignored, there is no page to cache.
I hope this help you, Ronan