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!
Request for feedback for SQL
- Rick Lipkin
- Posts: 2397
- Joined: Fri Oct 07, 2005 1:50 pm
- Location: Columbia, South Carolina USA
Re: Request for feedback for SQL
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
https://logicalread.com/sql-server-expr ... d-b5mhSyM8
Rick Lipkin
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
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
Code: Select all
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: 653
- Joined: Fri Oct 28, 2005 9:53 am
- Location: The Woodlands - Dallas - Scottsdale - London
- Contact:
Re: Request for feedback for SQL
Hi Rick,
Thank you!
Thank you!
- nageswaragunupudi
- Posts: 8017
- Joined: Sun Nov 19, 2006 5:22 am
- Location: India
- Contact:
Re: Request for feedback for SQL
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 )
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
G. N. Rao.
Hyderabad, India
- cdmmaui
- Posts: 653
- Joined: Fri Oct 28, 2005 9:53 am
- Location: The Woodlands - Dallas - Scottsdale - London
- Contact:
Re: Request for feedback for SQL
Dear Rao,
Thank you. Where can I download MariaDB?
Thank you,
Thank you. Where can I download MariaDB?
Thank you,
- nageswaragunupudi
- Posts: 8017
- Joined: Sun Nov 19, 2006 5:22 am
- Location: India
- Contact:
- Rick Lipkin
- Posts: 2397
- Joined: Fri Oct 07, 2005 1:50 pm
- Location: Columbia, South Carolina USA
Re: Request for feedback for SQL
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
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: 8017
- Joined: Sun Nov 19, 2006 5:22 am
- Location: India
- Contact:
Re: Request for feedback for SQL
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.
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
G. N. Rao.
Hyderabad, India