Re: Best database for web backend on Linux?

In article <70tntl$ftl$1@news.bctel.net>, "Thor" <thor@echidna.net> writes: >There are 2 main ways that systems use multiple CPUs to speed query >performance. The 2 main methods are spearheaded by Sybase and Oracle. >Sybase forms data affinity to a processor, while oracle defaults to using a >queue, such that all processors can perform parts of a query in parallel, >regardless of data affinity. This works well for queries that are "unkown". >Affinity mechanisms work well where the data paths are well understood. > Where can I read more about "data affinity" in the Sybase documentation? I'm curious how a programmer can help the data paths be well understood. Or, is this just a matter of using (precompiled) stored procedures? Also, this doesn't really make it clear to me whether a single query is spread over processors. Will that happen based upon the data affinity? That is, will semijoins be done on the processor to which the data is bound, with the results combined once those are done? Thanks... Andrew