i was using ms access for my web site(asp), and i know it is very slow when more user conneted to it...so i m thinking of upgrade it to sql server or mysql. but i have some problems in mysql(some of the query result is strange!!! which i donno how to solve it..anyone have the same problem?):bawling:

i never use sql server...is that similar to ms access?? all the query features..?
i m using windows xp, i still need to install sql server on my pc? or any tool...?pls help!! :confused:

if there is no problem on that...hehehe..looking for a web host to host it up...:D

"i have some problems in MySQL" - "some of the query result is strange".

This gives us no information about your problem, how do you expect us to help solve it?

I find myself saying this 15-20 times per day.

It depends on what you want to achieve.

Your average website can quite happily cope with a mySQL database.

However if you're going to want to stick a few million records in it, and make use of stored proceedures then it's ms sql.

Originally posted by Rich2k
It depends on what you want to achieve.
Your average website can quite happily cope with a mySQL database.
However if you're going to want to stick a few million records in it, and make use of stored proceedures then it's ms sql.

How can you define average site. Would you call WHT an average site.

:D

Well vbulletin ONLY works with mySQL so yes it is fine.

However you couldn't expect to run a site like Microsoft.com on a mysql server (not that they ever would :) )

mySQL is good because its free, and very common. Although it is my opinion that MSSQL is better with handling large databases. Just my 2 cents though.

Originally posted by glyn
i was using ms access for my web site(asp), and i know it is very slow when more user conneted to it...so i m thinking of upgrade it to sql server or mysql. but i have some problems in mysql(some of the query result is strange!!! which i donno how to solve it..anyone have the same problem?):bawling:

i never use sql server...is that similar to ms access?? all the query features..?
i m using windows xp, i still need to install sql server on my pc? or any tool...?pls help!! :confused:

if there is no problem on that...hehehe..looking for a web host to host it up...:D

You're very vague. Post the sql you're using in Access and MySQL, your results in each case, a sample data and which result you think is wrong and why.

It's like someone saying "My computer crashes.. anyone knows why my computer crashes?".. without giving any more info!

glyn,

First of all upgrading to MySql is a clever choise.
what language are you using? CGI? PHP? ASP?
what errors are you getting?

how can we help you if you do not state the problem?

MySQL and SQL server coding is very similar in ASP if not pretty much the same.

There may be a few code changes that you may have to do but it should be very minimal when you use a MySQL backend.

MySQL also seems to have a quicker response times.

MS Access is screwup sql. that's why MS is selling MS SQL. Access have more strange query than other. i think MySQL should be fine but you can alway get a copy of MS SQL from Kaaza ;)

Nah it's just that MS Access doesn't use Transact SQL

I think that if you are just outgrowing access that a loggical step forward is to MySQL. I am not a MS SQL or MySQL guru so I can't really tell all the exact diffrences. I think however that if you are used to access that you won't find features in access that are really missing in MySQL. I think MS SQL does have extra features with regard to user management, stored procedures and perhaps backup features but you probably don't need them because you won't find that in access either. Of course when you have already your Windows XP server at home and you don't have a problem with the "Kazaa trick" then I would go for a complete Microsoft.NET solution. If you just want to rent some server space by an ISP then I would not pay the extra money for the MS licenses.

Although I think MySQL 4 has stored proceedure support.

Of course MS SQL has Natural Language Querying which I haven't seen any one else do yet.

There's also the nifty MS Access to MS SQL upgrade option within MS Access which would make it seem like a more logical upgrade step to upgrade from one MS product to another.