topic-34720

Posts: 708

Joined: Fri Oct 28, 2005 09:53 AM

Request for feedback for SQL
Posted: Thu Oct 12, 2017 03:22 PM

Hello Everyone,

I am creating a new application that will run on Windows in a localized environment with possibility of remote data access from another location, possibly cross country here in USA.

My customer does not want to purchase high cost MS SQL.

Could you provide your professional opinion and the best SQL that I should utilize? I have seen a lot about MarioDB and wanted feedback on best SQL. There is an expectation that system may be processing more than 1000 transactions per week.

Thank you in advance for your help!

*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com

Rick Lipkin

Posts: 2706

Joined: Fri Oct 07, 2005 01:50 PM

Re: Request for feedback for SQL
Posted: Thu Oct 12, 2017 04:43 PM

Darrell

There is no limitation to the number of connections for the free version of Sql Server Express :

https://stackoverflow.com/questions/529 ... ition-free

However there are hardware Limitations

Code (fw): Select all Collapse

As found on MSDN, you can use SQL Server Express Edition in production environment but you have to consider some technical limitations:

maximum of 1 processor, up to 4 cores allowed
maximum memory utilized (per instance of SQL Server Database Engine) 1GB
maximum relational Database size 10GB

https://logicalread.com/sql-server-expr ... d-b5mhSyM8

Code (fw): Select all Collapse

Limitations

While the SQL Server Express editions can definitely be used for production databases, there are some important limitations that you need to be aware of:

The relational database engine is limited to the lesser of 1 socket or 4 cores.
The buffer cache of each instance is limited to 1MB of RAM.
If you have the SQL Server Express with Advanced Services edition, the Reporting Services components are limited to 4GB of RAM.
Databases are limited to 10GB of storage per database data file. FILESTREAM data does not count toward this limit.
SQL Agent is not present.

Rick Lipkin

cdmmaui

Posts: 708

Joined: Fri Oct 28, 2005 09:53 AM

Re: Request for feedback for SQL
Posted: Fri Oct 13, 2017 05:41 AM

Hi Rick,

Thank you!

*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Request for feedback for SQL
Posted: Fri Oct 13, 2017 02:06 PM

My preferences:
1. MariaDB ( free, powerful and no limitations )
2. SQLEXPRESS ( free. works same way as MSSQL server with limitations on datasize, etc. But these limitations are not at all important )

Regards

G. N. Rao.

Hyderabad, India

cdmmaui

Posts: 708

Joined: Fri Oct 28, 2005 09:53 AM

Re: Request for feedback for SQL
Posted: Fri Oct 13, 2017 02:23 PM

Dear Rao,

Thank you. Where can I download MariaDB?

Thank you,

*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Request for feedback for SQL
Posted: Fri Oct 13, 2017 02:27 PM

https://mariadb.org/

Regards

G. N. Rao.

Hyderabad, India

Rick Lipkin

Posts: 2706

Joined: Fri Oct 07, 2005 01:50 PM

Re: Request for feedback for SQL
Posted: Fri Oct 13, 2017 02:47 PM

Rao

Looking at the MariaDB site .. it appears there is a jconnector ... does jconnector have to be loaded as a client on each desktop ?

Rick Lipkin

nageswaragunupudi

Posts: 10733

Joined: Sun Nov 19, 2006 05:22 AM

Re: Request for feedback for SQL
Posted: Fri Oct 13, 2017 02:52 PM

No.
If you want to use ADO, we need to install ODBC connector.

But we advise using either built-in library in FWH or 3rd party libs like Dolphin or TMySql. In these three cases, we need to have a dll file in the exe folder. FWH provides everything that is required including libs and dlls.

So, it is just install MariaDB and go.

Regards

G. N. Rao.

Hyderabad, India

FiveTech Support Forums

Continue the discussion