Re: PostgreSQL and Firebird comparison via digg

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
    ... Do you know if using PostgreSQL a query or connection can have a priority set, so it can run quicker than other queries? ... in a POS system the reporting queries should have lower priority than the generated invoices insert queries. ... 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: How do I trun off casini web server?
    ... you may also need to switch to a multiproc machine to detect threading ... Under Server, click "Use custom server". ... server, but when I publish it to the web, which is using IIS (ASP.NET ... I cannot figure out how to switch my dev environment back to IIS so I can ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Genes Server Down?
    ... |> considered thoughts to the readers of rec.boats: ... |> |> Rec.boats at Lee Yeaton's Bayguide ... |threading on some other server just to compare? ...
    (rec.boats)
  • Re: InvalidCastException Using AzMan from ASP.NET
    ... threading model mismatch or permmision denied. ... To configure your ASP.NET application server to run in a service ... security context of the service account created for the application server. ... Microsoft Internet Information Services page on the Microsoft Web site at ...
    (microsoft.public.dotnet.framework.interop)
  • Re: Components for a client/server architecture
    ... A strong and fair threading model. ... using a normal Python interpreter on the server. ... Are there any standard protocols that make it easy to share objects ...
    (comp.lang.python)