Request for feedback for SQL

Request for feedback for SQL

Postby cdmmaui » Thu Oct 12, 2017 3: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
User avatar
cdmmaui
 
Posts: 689
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

Re: Request for feedback for SQL

Postby Rick Lipkin » Thu Oct 12, 2017 4: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: Select all  Expand view

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: Select all  Expand view

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
User avatar
Rick Lipkin
 
Posts: 2606
Joined: Fri Oct 07, 2005 1:50 pm
Location: Columbia, South Carolina USA

Re: Request for feedback for SQL

Postby cdmmaui » Fri Oct 13, 2017 5:41 am

Hi Rick,

Thank you!
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
cdmmaui
 
Posts: 689
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

Re: Request for feedback for SQL

Postby nageswaragunupudi » Fri Oct 13, 2017 2: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
User avatar
nageswaragunupudi
 
Posts: 10206
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: Request for feedback for SQL

Postby cdmmaui » Fri Oct 13, 2017 2:23 pm

Dear Rao,

Thank you. Where can I download MariaDB?

Thank you,
*~*~*~*~*~*~*~*~*~*
Darrell Ortiz
CDM Software Solutions, Inc.
https://www.cdmsoft.com
User avatar
cdmmaui
 
Posts: 689
Joined: Fri Oct 28, 2005 9:53 am
Location: Houston ∙ Chicago ∙ Los Angeles ∙ Miami ∙ London ∙ Hong Kong

Re: Request for feedback for SQL

Postby nageswaragunupudi » Fri Oct 13, 2017 2:27 pm

Regards

G. N. Rao.
Hyderabad, India
User avatar
nageswaragunupudi
 
Posts: 10206
Joined: Sun Nov 19, 2006 5:22 am
Location: India

Re: Request for feedback for SQL

Postby Rick Lipkin » Fri Oct 13, 2017 2: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
User avatar
Rick Lipkin
 
Posts: 2606
Joined: Fri Oct 07, 2005 1:50 pm
Location: Columbia, South Carolina USA

Re: Request for feedback for SQL

Postby nageswaragunupudi » Fri Oct 13, 2017 2: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
User avatar
nageswaragunupudi
 
Posts: 10206
Joined: Sun Nov 19, 2006 5:22 am
Location: India


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: MarcoBoschi and 13 guests