pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
single click, double query
4+ messages / 3 participants
[nested] [flat]

* single click, double query
@ 2005-12-15 12:18 Szabolcs BALLA <szballa@confinsystems.com>
  2005-12-15 13:23 ` Re: single click, double query Jaime Casanova <systemguards@gmail.com>
  2005-12-15 14:59 ` Re: single click, double query Stephan Szabo <sszabo@megazone.bigpanda.com>
  0 siblings, 2 replies; 4+ messages in thread

From: Szabolcs BALLA @ 2005-12-15 12:18 UTC (permalink / raw)
  To: pgsql-admin

Hi,

I have a strange problem with psql 7.4.7.
I have customers who run xp, with sp1 (with sp2 no problem), when they 
report from our web-based application they send a query
after a single click. The same queries have been posted twice within a 
few milliseconds.
How can I forbid this on db server side? Is it possible?
note: I can't forbid a "too fast" connections by IP because they come 
throught firewall.

Thanks,
Szabek




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: single click, double query
  2005-12-15 12:18 single click, double query Szabolcs BALLA <szballa@confinsystems.com>
@ 2005-12-15 13:23 ` Jaime Casanova <systemguards@gmail.com>
  2005-12-15 13:36   ` Re: single click, double query Szabolcs BALLA <szballa@confinsystems.com>
  1 sibling, 1 reply; 4+ messages in thread

From: Jaime Casanova @ 2005-12-15 13:23 UTC (permalink / raw)
  To: Szabolcs BALLA <szballa@confinsystems.com>; +Cc: pgsql-admin

On 12/15/05, Szabolcs BALLA <szballa@confinsystems.com> wrote:
> Hi,
>
> I have a strange problem with psql 7.4.7.
> I have customers who run xp, with sp1 (with sp2 no problem), when they
> report from our web-based application they send a query
> after a single click. The same queries have been posted twice within a
> few milliseconds.
> How can I forbid this on db server side? Is it possible?

if you see the problem just in clients with xp sp1 and not with xp sp2
then the problem is in the client not in the server...

upgrade your xp clients to sp2...

> note: I can't forbid a "too fast" connections by IP because they come
> throught firewall.
>
> Thanks,
> Szabek
>
>


--
regards,
Jaime Casanova
(DBA: DataBase Aniquilator ;)



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: single click, double query
  2005-12-15 12:18 single click, double query Szabolcs BALLA <szballa@confinsystems.com>
  2005-12-15 13:23 ` Re: single click, double query Jaime Casanova <systemguards@gmail.com>
@ 2005-12-15 13:36   ` Szabolcs BALLA <szballa@confinsystems.com>
  0 siblings, 0 replies; 4+ messages in thread

From: Szabolcs BALLA @ 2005-12-15 13:36 UTC (permalink / raw)
  To: Jaime Casanova <systemguards@gmail.com>; +Cc: pgsql-admin

Yes, but they are our clients, and I can't say for them: please upgrade 
your client because if you use our applications the db server will have 
a performance problem...:(

Jaime Casanova wrote:

>On 12/15/05, Szabolcs BALLA <szballa@confinsystems.com> wrote:
>  
>
>>Hi,
>>
>>I have a strange problem with psql 7.4.7.
>>I have customers who run xp, with sp1 (with sp2 no problem), when they
>>report from our web-based application they send a query
>>after a single click. The same queries have been posted twice within a
>>few milliseconds.
>>How can I forbid this on db server side? Is it possible?
>>    
>>
>
>if you see the problem just in clients with xp sp1 and not with xp sp2
>then the problem is in the client not in the server...
>
>upgrade your xp clients to sp2...
>
>  
>
>>note: I can't forbid a "too fast" connections by IP because they come
>>throught firewall.
>>
>>Thanks,
>>Szabek
>>
>>
>>    
>>
>
>
>--
>regards,
>Jaime Casanova
>(DBA: DataBase Aniquilator ;)
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
>
>  
>




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: single click, double query
  2005-12-15 12:18 single click, double query Szabolcs BALLA <szballa@confinsystems.com>
@ 2005-12-15 14:59 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
  1 sibling, 0 replies; 4+ messages in thread

From: Stephan Szabo @ 2005-12-15 14:59 UTC (permalink / raw)
  To: Szabolcs BALLA <szballa@confinsystems.com>; +Cc: pgsql-admin

On Thu, 15 Dec 2005, Szabolcs BALLA wrote:

> Hi,
>
> I have a strange problem with psql 7.4.7.
> I have customers who run xp, with sp1 (with sp2 no problem), when they
> report from our web-based application they send a query
> after a single click. The same queries have been posted twice within a
> few milliseconds.
> How can I forbid this on db server side? Is it possible?

Not easily that I can think of.  Something between the two that passes
connections but filters queries might be reasonably easy to make. I see
two possible problems with this on the server side though.  First, if
those are coming in separate connections then you have to either delay for
the first query or pay the cost of making a database backend even if
you're going to drop it if its a duplicate. Second, if it's possible for
two client instances to send the same query then you could break the
application in the other direction where the second client gets no
response.



^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2005-12-15 14:59 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2005-12-15 12:18 single click, double query Szabolcs BALLA <szballa@confinsystems.com>
2005-12-15 13:23 ` Jaime Casanova <systemguards@gmail.com>
2005-12-15 13:36   ` Szabolcs BALLA <szballa@confinsystems.com>
2005-12-15 14:59 ` Stephan Szabo <sszabo@megazone.bigpanda.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox