Re: PostgreSQL and Firebird comparison via digg

Tony:

Do you know if using PostgreSQL a query or connection can have a priority set, so it can run quicker than other queries?
For example, in a POS system the reporting queries should have lower priority than the generated invoices insert queries.

Thanks in advance
Carlos

Tony Caduto escribió:
Donald Shimoda wrote:
Tony Caduto escribió:

Not sure why Donald needs multi threads for his daily database usage :-)


Fire 10 large SELECTS in a 24x7 application server and you can see why you need it. ;)

Who can mislead the sense of threads in that days?




I do many more than 10 large selects in many 27x7 applications with PostgreSQL.

Since when has firebird supported parallel query execution? Far as I know when you run a query in Firebird it runs in the context of that thread. So like I said the only advantage is in terms of how long it takes to connect to the server to run another query.

If you run 1 select right after each other on the same connection there is going to be no difference in how fast those queries execute.

Have you even tried the latest native win32 version of PostgreSQL?

I know a lot of people are basing this whole threading thing on when PostgreSQL only ran on windows via cygwin Unix emulation and yes that did suck, but that is a thing of the way way past.

And the whole threading thing is completely mute on Unix platforms which you should be running anyway for things like PHP and Apache.

Later,

Tony

.

Relevant Pages

  • Re: PostgreSQL and Firebird comparison via digg
    ... I do many more than 10 large selects in many 27x7 applications with PostgreSQL. ... Far as I know when you run a query in Firebird it runs in the context of that thread. ... So like I said the only advantage is in terms of how long it takes to connect to the server to run another query. ... I know a lot of people are basing this whole threading thing on when PostgreSQL only ran on windows via cygwin Unix emulation and yes that did suck, but that is a thing of the way way past. ...
    (borland.public.delphi.non-technical)
  • RE: Dynamically referencing a recordset?
    ... through that recordset to set the query parameters in VBA. ... to be the one who had to modify 1440 queries if there is a change in the ... different table schema, then you need 3, one for each record type. ... This is a database that tracks the production on records in another ...
    (microsoft.public.access.modulesdaovba)
  • Re: Was: what does "serialization" mean?
    ... > the specific queries up front. ... that the NEXT time the query is run the query is fast, ... data base, don't know squat" when in fact the Donald clone doesn't ... >> WHATEVER would probably be a separate query to summarize total sales. ...
    (comp.programming)
  • Re: Official Status of SQLServer 2005 ADP
    ... I have said that the support for SQL passthrough ... queries under MDB was bad and worst than the one offered by ADP while you ... > attempt to "pass through" every Access query against a linked ODBC ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Cluster synchronize
    ... queries per unit time. ... CPU is the ONLY bottleneck. ... increase in query capacity. ... queries that perform sequential I/O or queries performing random I/O. ...
    (microsoft.public.sqlserver.clustering)