Il 14/09/2011 19:34, Alex Nikitin ha scritto:
> Perhaps if I, or we can understand your application a little better,
> we could suggest better solutions, just remember that you are not the
> first person to have to solve these similar issues. I can help you if
> you want, glimpse over your database
On Wed, Sep 14, 2011 at 4:04 AM, Marco Lanzotti wrote:
> Il 13/09/2011 20:58, Alex Nikitin ha scritto:
> > Correction on Marco's post. You can absolutely stop a mysql query
>
> I know I can stop a query, but I don't know how to realize HTTP client
> has closed connection during query execution.
>
Il 14/09/2011 17:35, Jim Lucas ha scritto:
>
> SELECT ... FROM ... WHERE ... AND (1=1 OR 'unique value');
>
> add 'unique value' to your session data and then, when the person changes the
> selected fields and starts to execute another query, first, you could search
> to
> see if an SQL statement
On 9/14/2011 1:04 AM, Marco Lanzotti wrote:
> Il 13/09/2011 20:58, Alex Nikitin ha scritto:
>> Correction on Marco's post. You can absolutely stop a mysql query
>
> I know I can stop a query, but I don't know how to realize HTTP client
> has closed connection during query execution.
>
> My query
Il 13/09/2011 20:58, Alex Nikitin ha scritto:
> Correction on Marco's post. You can absolutely stop a mysql query
I know I can stop a query, but I don't know how to realize HTTP client
has closed connection during query execution.
My query count how many records match selected fields in a 50M rec
Absolutely, it was only a minor correction of a sub-point.
--
The trouble with programmers is that you can never tell what a programmer is
doing until it’s too late. ~Seymour Cray
On Tue, Sep 13, 2011 at 3:20 PM, Jim Lucas wrote:
> On 9/13/2011 11:58 AM, Alex Nikitin wrote:
> > On Tue, Sep 1
On 9/13/2011 11:58 AM, Alex Nikitin wrote:
> On Tue, Sep 13, 2011 at 11:44 AM, Jim Lucas wrote:
>
>> On 9/12/2011 7:40 AM, Marco Lanzotti wrote:
>>> Hi all, I'm new in the list and I already have a question for you.
>>> I'm running an heavy query on my DB in a PHP script called by AJAX.
>>> Becau
On Tue, Sep 13, 2011 at 11:44 AM, Jim Lucas wrote:
> On 9/12/2011 7:40 AM, Marco Lanzotti wrote:
> > Hi all, I'm new in the list and I already have a question for you.
> > I'm running an heavy query on my DB in a PHP script called by AJAX.
> > Because client often abort AJAX connection to ask a n
On 9/12/2011 7:40 AM, Marco Lanzotti wrote:
> Hi all, I'm new in the list and I already have a question for you.
> I'm running an heavy query on my DB in a PHP script called by AJAX.
> Because client often abort AJAX connection to ask a new query, I need to
> stop query because DB will be too loade
Hi all, I'm new in the list and I already have a question for you.
I'm running an heavy query on my DB in a PHP script called by AJAX.
Because client often abort AJAX connection to ask a new query, I need to
stop query because DB will be too loaded.
When AJAX connection is aborted, PHP script doesn
10 matches
Mail list logo
