Re: PostgreSQL and Firebird comparison via digg


"Tony Caduto" <support@xxxxxxxxxxxxxxxxxxxx> wrote in message
news:473ca39d@xxxxxxxxxxxxxxxxxxxxxxxxx
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.

Ah yes, a thing of the past.

Well, so is "Firebird 1" that you mention. And many "issues" are
a "thing of the past" whenever you touch the Firebird subject.

This "digg post", in which you are trying to get your own website/comparison
to the public is yet another attempt of you to talk down at Firebird.


--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


.

Relevant Pages

  • Re: MailMerge hangs and crashes with Access on Server
    ... Since I am fairly new to working in this environment, I am not sure what you mean by an "Access group" with help to restructuring the query? ... "Peter Jamieson" wrote: ... All I know is that the performance of queries depends to a large extent on whether, for example, a join is performed on the client side, or on the server side, incurring no network traffic and potentially benefitting from caching on the server. ... There are no dialog boxes, and actually, I have now split the database, and have kept the Word templates and the Access frontend locally on my machine, and moved the backend to the server. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MailMerge hangs and crashes with Access on Server
    ... restructuring a complex query. ... discards 99% of them), or on the server side, incurring no network ... the database is locked and Word will not open the data source. ... have kept the Word templates and the Access frontend locally on my machine, ...
    (microsoft.public.word.mailmerge.fields)
  • Re: MailMerge hangs and crashes with Access on Server
    ... I have mapped out the path to the final query that is used to get to the ... the database is locked and Word will not open the data source. ... have kept the Word templates and the Access frontend locally on my machine, ... and moved the backend to the server. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Single-Threading / Performance issues
    ... SQL Server MVP ... > Early this year my database was migrated from a single CPU, ... (when a long select query is running, ... server guy also sez it's not his problem. ...
    (microsoft.public.sqlserver.server)
  • Single-Threading / Performance issues
    ... In the database properties take off auto close and auto ... Other things you can look are server stuff. ... In the meanwhile get the book SQL Server 2000 Performance ... > From Query Analyser, I run my import proc - which first ...
    (microsoft.public.sqlserver.server)