RC — Thu, 02 Mar 2000 20:19:00 +0000

Peter

I don't suffer any problems with Access, but then again I don't think I ever have more than 15 people at a time using the site. It is not mission critical and it is a simple "pull data out and post it" operation. There is no database writing or anything like that. So, for my needs, Access is fine.

roBofh — Wed, 01 Mar 2000 20:04:00 +0000

MySQL for a couple years now, used Sybase ASE for Linux for a little while, been meaning to try postgresql (people have really been recommending that to me, but I've just been too busy to install it and try it out/learn syntax).

JP Stones — Wed, 01 Mar 2000 16:57:00 +0000

We use ASP (ahhhhhh).
Pete,
I want to setup Oracle 8 at home on my (soon) win2000 machine and then setup PWS or similar server so I can start mocking up a database for one of my sites. I already use SQL but have never installed Oracle or PWS and use them on a very basic lever at work.

Have you ever done this?
JP

Peter J. Boettcher — Wed, 01 Mar 2000 16:24:00 +0000

RC,

Do you suffer any performance problems using Access on the web? I've tried using Access for a couple projects but anytime you get more than 10-15 heavy users I find that Access becomes very slow and unstable.

In my experience Access is ok for light use, but nothing mission critical that's for sure.

Regards,
Peter J. Boettcher

RC — Wed, 01 Mar 2000 15:15:00 +0000

Access 97 Database with Coldfusion 4.0.

Peter J. Boettcher — Wed, 01 Mar 2000 14:25:00 +0000

JP,

Oracle8 is actually the better database from a performance standpoint. It's the cost and ease of integration with the rest of the Microsoft products which is why I develop most of my sites with SQL (I also use NT server for most of my projects).

How are you interfacing with Oracle? ASP, PHP, CGI, other?

Regards,
Peter J. Boettcher

JP Stones — Wed, 01 Mar 2000 14:16:00 +0000

Oracle8 here at work. Any comments of how good it is?
JP

Peter J. Boettcher — Wed, 01 Mar 2000 13:57:00 +0000

I thought it might be interesting to find out what everyone is using as far as databases go.

I focus mainly on SQL 7 with ASP but I also use Access for testing and have used mySQL in the past.

So let's hear what you're using (even if you're using text files

Regards,
Peter J. Boettcher