Get ready for BLACK FRIDAY shopping starting in

Forums

This topic is locked

Access vs. SQL Run Time Speed

Posted 19 Apr 2002 17:55:00
1
has voted
19 Apr 2002 17:55:00 aegis kleais posted:
I know SQL is far more powerful then Access databases, but as of now I know know how to use Access. I was wondering, "Does SQL work more efficiently on server end then Access?" I've noticed that when I make ASP pages and try to access them, depending on the information, I can expect to wait 3-120 seconds for a response. When I ping the server, nothing is more then 80ms (I'm on cable) and the most populated database table right now only has 190 records.

Replies

Replied 19 Apr 2002 21:19:37
19 Apr 2002 21:19:37 Joel Martinez replied:
of course, it's very much faster... I think that the price tag pretty much ensures that <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

It's all about your project.. if you need faster response times, then it's time to upgrade. Of course you can always go with something like mysql or firebird (free database servers)

Joel Martinez
MX inSite Magazine
The Complete Resource for Macromedia designers & developers
Sign up for your free electronic Preview Issue
www.mxinsite.com
Replied 21 Apr 2002 03:35:25
21 Apr 2002 03:35:25 aegis kleais replied:
Thanks for the input. Problem is nowadays that things change so often. Learn one thing and bam, another comes out.
Like ASP. I'm learning it now and this ASP.NET comes out. I also want to learn SQL. Hope they don't one up that too soon &gt;<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Thx again.

Reply to this topic