openmind — Sun, 09 Dec 2001 13:20:57 +0000

Thankyou for putting it into perspective hotcut. From what you said it would seem I would have a LONG way to go b4 I need to consider spending a coupla thousand dollars!!

Which is a relief coz Christmas is just round the corner and my kids would lose out!!! :santa:

hotcut — Sat, 08 Dec 2001 22:40:48 +0000

Hi...

Let me give my comment here.

You say taht you are serving around 2.5K pages a month... That is VERY little.
I am currently serving nearly 200,000 pageviews a DAY.

I am now on an SQL server though.

However, back in the days when I was on access, I served around 40K a day. That is a lot, and it was a bit slow (considdering that the database was at more than 70 megs).

I do not really believe that it would be worth upgrading for you; If it takes 5 seconds to load a page, I wouldn't see that as a problem; most people got 5 seconds to spare.

However, once you get used to SQL Server, you cannot live without it! Its a great database, and makes it all very easy to work with.

Thats my 5 cents.

~Casper Bang

openmind — Thu, 06 Dec 2001 21:40:43 +0000

Of course it also helps if your arunning Windows NT....which I'm not...

Peter J. Boettcher — Thu, 06 Dec 2001 14:35:31 +0000

Web connections (IIS) do not count as one connection (license), if you have a site that averages around 10 concurrent users, then you will have to get 10 licenses. For large sites with hundreds of concurrent users then the per processor licence is the way to go (unlimited connections)

cyril_kearney — Thu, 06 Dec 2001 02:15:31 +0000

--------------------------------------------------------------------------------
Originally posted by Peter J. Boettcher

The actual cost is around $2,000 (US) for the standard edition with a 5 user license. I don't remember the Enterprise edition pricing, but it's a lot more. The 5 user license only gives you 5 connections so you'll want to go for the Per Processor license which gives you unlimited connections, but it costs $5000 (US) per processor.

--------------------------------------------------------------------------------

I paid $1600 for SQL Server2000 which includes OLAP extensions. Your whole Internet connection is counted as a single user under IIS and you still have 4 more.

If your site is very small perhaps Access or MySQL is the answer. If you see this as a 36 month investment. It costs less $50 a month to use a world class database. I don't know the price of Oracle or DB2 but I expect that when viewed over a three year period that the cost is moderate.

openmind — Mon, 19 Nov 2001 19:14:55 +0000

Oh dear, major problem....A trial version is not avaliable for Win 98...darn, back to the drawing board

openmind — Mon, 19 Nov 2001 19:04:11 +0000

Well If ound the demo and you can download it here if you have about 24 hours spare as its a 340 MB file!!! I was gonna order the CD but I'm a tight git and wont pay for shipping on something I can get for free! I think I'll download it over the next week or so (GoZilla is a wonderful toy) and burn it onto a CD myself..

Thanx for all your help Peter, I'll have a play about and come back to you if I get stuck!

Cheers

Peter J. Boettcher — Mon, 19 Nov 2001 01:41:16 +0000

You don't have to use Enterprise Manager but it will save you having to write queries that you could do in Enterprise Manager with one click. To get Enterprise Manager just apply for the demo SQL Server 2000 CD (I don't think you can download it anywhere), then install only the client tools. Don't worry it doesn't expire.

Remember this is a big step up from Access, and the learning curve is steep, but if you're committed to it then you should be fine.

openmind — Sun, 18 Nov 2001 22:34:43 +0000

So my database is stored on my hosts server right? So where can I download Enterprise Manager? I've searched Mico$ofts site but to no avail. It doesn't even pointyou in the right direction to upgrade from access 2000!!

Give it to me straight...Am I worrying about nothing or should I really retrain my brain (and site) to work with SQL server?

Mark Hensler — Sun, 18 Nov 2001 22:30:43 +0000

a) Enterprise Manager is just a GUI client tool that connects to remote M$ SQL servers.

b) No, you don't NEED to run a local SQL server. You can have your scripts connect to remote SQL servers.