On 8 Sep 98, at 13:57, Bruce Young wrote:
> Hi
> We have the following senario and most of this is not negotiable except the
> DB engine... so no Linux comments please. :)
> This is being done on a WinNT4 server using Cold Fusion and Access. My
> "manager" asked me to ask around as he constantly feels that Access is not
> up to it. I think he just wants a bit of justification/encouragement to go
> to MSSQL server.
-- snip --
> Anyway, once this is all in the Access DB I can manipulate it at will and
> that aspect works just fine.
> The server that does this has plenty of power and RAM but it still maxes
> out the CPU while it is converting the info from a text file to the DB
> format. It would quite often fail on that server if I asked CF to do a
> "transaction"; a method of keeping the old info while the new stuff was
> being put in with the ability to roll back if it all went horribly wrong.
-- snip --
> Ok... the question is... what are your thoughts about Access and MSSQL
> servers. Don't tell me it depends of load, transactions, number of records
> etc... ;-)
It depends on load, transaction, number of records etc... Just
joking...
This is what I can argue from my experience and what I've heard:
Access is slower then MS SQL but MS SQL is very resource
hungry.
ODBC driver for Access should be less efficent than ODBC driver
for MS SQL. Opening connections with an Access DB should be
slower.
My experience is limited to ASP and ODBC.
It depends on your programming "style" if connection
number=transaction number or if connection number<transaction
number.
We have a small DB (5000 records, about 10 fields) in MS SQL
imported weekly from a text file (3Mb). I didn't program the system
and I didn't try to look at the DB while it is updated but the time
required is very short (5 to 10 minutes).
What I haven't told you is the system is a dual PPro 256Mb RAM
and 2 very fast SCSI HD.
I'm developing ASP proggies on a P133 48Mb RAM machine with 2
EIDE HD (2Mb/sec) and I use Access DB... well things are slow
and I'm the only user on my LAN.
There is a tool to upsize an Access DB to an SQL DB on MS
site... it's not hard to find... give a look at MS site I think you'll find
something interesting to read about the transition from Access to
SQL ( http://support.microsoft.com ??).
I can't assure what you'll find there will be really unbiased but it is a
good place to start from.
That is all I can say.
Good luck.
-------------------------------------------
Ivan Sergio Borgonovo [EMAIL PROTECTED]
Webmaster Gorilla Bookstore http://www.gorilla.it
Tel. +39 2 3311105/34530455 Fax. +39 2 34531591
Via Mac Mahon 9, Milano, Italy
-------------------------------------------
____________________________________________________________________
--------------------------------------------------------------------
Join The Web Consultants Association : Register on our web site Now
Web Consultants Web Site : http://just4u.com/webconsultants
If you lose the instructions All subscription/unsubscribing can be done
directly from our website for all our lists.
---------------------------------------------------------------------
