Which database server should I use?

 Top  Previous  Next

For ease of initial use while testing out the trial AyaNova, it is suggested to use the  stand-alone default installation so you can initially check out all AyaNova features without having to perform any additional configuration.

 

Once you have confirmed that AyaNova features meet your needs, and than wish to trial use in your actual network environment to confirm access and speed, you need to perform the steps configure AyaNova for network use

 

You have three choices for networking AyaNova:

•AyaNova networked using the Firebird Server 2
•AyaNova networked using SQL Express
•AyaNova networked using SQL Server

 

Speed and access are highest with SQL Express and SQL Server use, but the difference between SQL and network Firebird may be negligible for most AyaNova users due to the differences being points of a second.

 

Do note that once data has been converted from the embedded Firebird to the network Firebird or from Firebird to SQL Server, data can not be converted back.

 

 

A networked AyaNova Firebird database would be used by those with the following:

•The AyaNova database will be shared and accessed by one or more networked computers
•And/or multiple instances of the AyaNova program will be run

 

•The network Firebird engine is available for download via the link found on the AyaNova web site
• Refer to the network Firebird installation and configuration steps.

 

 

A networked AyaNova SQL database would be used by those with the following:

•The AyaNova database will be shared and accessed by one or more networked computers
•And/or multiple instances of the AyaNova program will be run
•A higher database performance is required due to the amount of entered data and number of users accessing
•This includes SQL Server Express and SQL Server 2005 or higher with all Microsoft applicable service patches.

 

•Refer to either the network SQL Express configuration steps or the network SQL Server configuration steps

 

We can not provide absolute benchmarks as many factors come into play determining whether the network Firebird meets your needs, or you should move to SQL Server.

 

In addition to the amount of data – there is also the type of data (i.e accessing workorder records will always take more access time than accessing the same number of client records), the hardware of the server hosting the database, hardware of the computer running the program, present demands on the server, number of user accessing,  and network speed.

 

If in a network environment, it is suggested to initially use the network Firebird configuration because of its least footprint (in server resources it uses compared to SQL). If you are experiencing noticeable performance aspects and your server is not overloaded, obtain the free SQL Server Express from Microsoft if do not have the paid for SQL Server.