Want to Upgrade From Access - Questions

Hi

Im looking for more speed primarily .. connection pooling, etc ..

Are there alot of changes in code from using an Access DB to an SQL Server?
Im using Lots of GetRows right now ... and then some regular recordset stuff ( myVar = objrs('myField') )

Also, which would be best for a total SQL Server Noob ... MS SQL or MySql ..?
Which is faster ..?

Ive downloaded both but waiting to install them until i decide which one im going to use ..
Also, i downloaded SQL Server 2005 Express Edition, dont have the full version .. can this still be used on DASP?

Thanks
Rory

Bahamas Security - BahamasSecurity.com
Bahamas Real Estate - KnowlesRealty.com

 

MS SQL Server is always recommended over MySQL for ASP and ASP.net hosting. Though, you should be able to use both just fine.





Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

 

Thanks Joel ..

I installed both in the end ... MS SQL is just so slow on my PC so i decided to leave that for now ..
MySql couldt figure out the login stuff right now .. I have alot of security on my PC which I cant open up ...
So will have to leave all this for right now ... until I get a second PC to work with ..

Quick question .. when i close out my browser page and then later on go back to my site on my PC (the local development version) ...
it takes a while the first time it accesses the database .. I have HTTP Keep alives enabled and is default 900 seconds ..
Is there something else I need to do or is this how it is on your server also .. as it can take 2 seconds in some cases to run the ASP with database queries, while once it has loaded the first time it can be like 0.02 seconds or less (its not exact but it still helps test the output speed) ... Im going to use a text file cacheing method anyway which will take care of most of that speed issue, but there will still be queries that will need to run without the cached files ...

Thanks
Rory

Bahamas Security - BahamasSecurity.com
Bahamas Real Estate - KnowlesRealty.com