pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedsingle click, double query
4+ messages / 3 participants
[nested] [flat]
* single click, double query
@ 2005-12-15 12:18 Szabolcs BALLA <szballa@confinsystems.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 13:23 Jaime Casanova <systemguards@gmail.com>
parent: 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 13:36 Szabolcs BALLA <szballa@confinsystems.com>
parent: Jaime Casanova <systemguards@gmail.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 14:59 Stephan Szabo <sszabo@megazone.bigpanda.com>
parent: Szabolcs BALLA <szballa@confinsystems.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