Welcome Visitor, Please Login or Register Now Thursday, October 19, 2017 04:28 PM 
New Topic   New Reply
Search for:
Author Message
bhlaserjet bhlaserjet's personal page
Registered Member
Posts: 88 Display member's posts
Joined: 10-19-17 04:28 PM
Member Offline
View Member's Profile Send private message
 
Back to top
MSsql Connection Edit Delete Reply with quote Quote
First Post Posted on: 12-17-16 02:52 PM next post first post

I'm trying to connect to microsoft mssql database. To see if I get better performance I don't no much at all

about database's so a step by step would be helpful. looked on forum, but found no setup demo. I especially

don't understand SQL Data Source Name (DSN):


SQL Host: SQL Database Name:

SQL Database User name:

SQL Database Password:

SQL Data Source Name (DSN):


By the way. I found a good article on mysql tunimg.  And did what you sugjested.  A little mysql to machine

tunning went a long way. It's much faster now! 

https://www.percona.com/blog/2014/01/28/10-mysql-settings-to-tune-after-installation/

Thanks for your advice Bob

I was way off base

mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 10-19-17 04:28 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: MSsql Connection Edit Delete Reply with quote Quote
Reply #: 1 Posted on: 12-17-16 02:58 PM next post previous post

MySQL server tuned on a Linux server is much faster than any windows system. So save your time on windows system at all.

Yes tuning MySQL server is everything about speed and performance, of course the more RAM and much better if you get

SSD hard drives later when you get traffic, SSD will make a factor or x10 and above in speed of everything.

If you want to try a Windows database you just use the data you get from your hosting for it and in the admin select

the drive to be MSSQL, that's all.

Thanks



Mewsoft Support
www.mewsoft.com

mewsoft mewsoft's personal page
Administrator Team Member
Posts: 5381 Display member's posts
Joined: 10-19-17 04:28 PM
Location: knxoville, TN, USA
Member Offline
View Member's Profile Visit member's website Mewsoft Corporation Send private message ICQ Messenger: ICQ AIM Messenger: AIM YIM Messenger: Yahoo MSN Messenger: MSN
 
Back to top
Re: MSsql Connection Edit Delete Reply with quote Quote
Reply #: 2 Posted on: 12-18-16 09:52 AM last post previous post

MySQL server tuned on a Linux server is much faster than any windows system. So save your time on windows system at all.

Yes tuning MySQL server is everything about speed and performance, of course the more RAM and much better if you get

SSD hard drives later when you get traffic, SSD will make a factor or x10 and above in speed of everything.

If you want to try a Windows database you just use the data you get from your hosting for it and in the admin select

the drive to be MSSQL, that's all.

Thanks


Mewsoft Support
www.mewsoft.com

Page 1 of 1
Go to page:

New Topic   New Reply Mark Unread
Jump to:  
Delete   Move     Lock   +Favorits   +Notify   Print