Community
Showing results for 
Search instead for 
Do you mean 
Reply

Need for MSQL

Accepted Solution Solved
Copper Super Contributor
Posts: 77
Country: United States
Accepted Solution

Need for MSQL

I use ACT as a standalone contact manager--no sharing, no communications, no companies,etc. Do I need all this MSQL server stuff??

Accepted Solutions
Solution
Accepted by topic author tiotaco
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Need for MSQL

Yes.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129

View solution in original post


All Replies
Solution
Accepted by topic author tiotaco
‎09-25-2015 03:20 AM
Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Need for MSQL

Yes.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129
Copper Super Contributor
Posts: 77
Country: United States

Re: Need for MSQL

Thanks, seems much ado for my simple needs.
Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Need for MSQL

The MSSQL server actually hosts the database. This is makes it similar to the file manager portion of Windows. No Window program directly accesses the files on the hard drive, the program requests the file from the file manager and it then opens the file for the program. The program doesn't care where the data is actually stored on the hard drive. With ACT! 6 and before, ACT! directly managed the storage and retrieval of information in the ACT! database. The result was that performance declined rapidly as the database became larger. With MSSQL, ACT! is relieved of knowing how the database information is stored and much large databases can be used without the decline in performance.
Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129