MSSQL2005 vs MySQL5 with VB2005 Performance ?
Hi there, im curious to know which way would be better...
if my serverside app has to constantly hit a database if its a local database, will performance become an issues based on either mssql2005 or mysql5 , i guess what im asking is which is faster and is it going to cause lag if its a local database, or would that not matter if its local?
Thanks
[370 byte] By [
vchatlive] at [2007-11-11 10:19:49]
# 1 Re: MSSQL2005 vs MySQL5 with VB2005 Performance ?
I don't think your choice of local database will make much difference, but the only way to know for sure is to test with both.
# 2 Re: MSSQL2005 vs MySQL5 with VB2005 Performance ?
would it theoretically be better having it local to the serverside program than to store the database on a seperate server? as far as speed and performanace are concerned
# 3 Re: MSSQL2005 vs MySQL5 with VB2005 Performance ?
It depends where your bottlenecks are. Is the limiting factor network bandwidth, or server resources (RAM, processor, etc.)? If your server has plenty of resources, then it will likely be faster to run the database locally. If your server is maxed out, then it may be faster to run the database on a separate machine. Only testing in your specific environment can give you the correct answer.
