Re: SMP & threads for SQL queries

If this is a "real app" I would suggest using software you have to pay for (sorry Linus, FSF, GNU, ...) at least for the OS and RDBMS. On Intel you can run Windows NT, Solaris, UnixWare, SCO, OS/2 with Sybase, ORACLE, MS SQL (NT only). DB2/2 (OS/2 only). I just read of some smashing results with Sybase on UnixWare and MS SQL on Windows NT. Personally, Sybase on Windows NT works well too. Lots of good choices.

Cheers
Jay Walters

scottv1_at_airmail.net (Van Scott) wrote:
>In article <322C8566.3382B8E3_at_fc.net>, linas_at_fc.net says...
>>
>>Hi,
>>
>>Can anyone recommend an sql server that supports SMP
>>(symmetric multiprocessing) & threads for queries?
>>
>>We are looking at buying a 2-way or 4-way pentium pro,
>>and running linux on this. It seems that the popular
>>(i.e. cheap) linux databases (msql, justlogic, empress)
>>may not support this. clearly, its a waste to buy an
>>MP system if the databases won't make use of the extra
>>processors. The database would be mostly queried, and
>>very, very rarely updated.
>>
>>Anyone with experiences, please report ...
>>
>>Also, what is the largest database anyone has run
>>under linux? More than a few gigs? What's the largest
>>amount of real memory anyone has used? Has anyone
>>attempted to plug in 512 meg of simms, or more into
>>a linux box?
>>
>>--linas
>>linas_at_fc.net
>
>Hi Linas.
>Sybase SQL Server supports SMP boxes under all
>major flavors of UNIX (Solaris, HP-UX, AIX, etc)
>The SQL Server is also multi-threaded--tho these
>are not native OS threads.
>
>Sybase SQL Server won't run on Linux as
>far as I know, tho I have heard ideas about
>using Sybase binaries for SCO under Linux.
>
>SQL Server under NT should make use of
>multiple processors.
>
>Is your application going to be processor-
>intensive?
>
>
>Van
>
>
Received on Wed Sep 04 1996 - 00:00:00 CEST