Re: SMP & threads for SQL queries

In article <322C8566.3382B8E3@fc.net>, linas@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@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