Re: SMP & threads for SQL queries

Linas Vepstas wrote: > > 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. > Not to pick on Linas, but .... Linux is good for a home hobby system. Like FreeBSD. But to risk a business on it? You would be better off getting a real OS like Solaris. Or even (ick!) SCO. Then run a real database like Informix. Yeah, you can do some hacks to get it to work, but its like buying a used bus held together with bailing wire. The money you save up front, you spend in repairs. Just my $.02. -Mikey