Performance of SQL Server

aware_support

Just wanted to share the results of some benchmark testing of SQL Server.

It is MUCH faster than MySQL (let alone Derby). Migrating to SQL Server can make a big difference in terms of your Aware IM application performance

(even SQL Server Express edition)

kklosson

Support,

Do you have any specifics in terms of function performed and time differences? Secondly, what is involved in migrating if one decides to do so? Got anything written down on that? If so, please share.

ACDC

Yes I would love to know more. You say much faster, this is quite a revelation. Do you have any idea why it would be much faster -

aware_support

Why is it faster? Presumably because SQL Server database engine and/or JDBC driver are a lot more efficient than MySQL.

We do not have any benchmark results for this, but we have noticed a CONSIDERABLE speed improvement for a particular application of one of our customers after he had migrated it to SQL Server. The application is very large and includes a number of operations that has many rules with database access.

He used some inexpensive tool to perform data conversion from MySQL to SQL Server.

We then started to play with some of our smaller applications and speed difference was very noticeable, especially when displaying query results.

intra

I would be keen to see results for MariaDB vs MySQL.

MariaDB was forked off MySQL as pure open source and seems to have some performance improvements over the Oracle sponsored alternative. MariaDB also comes with its own JDBC drivers and I believe they are faster than connectorj. (Subjective as you can always tweak parameters )

Support, would including a proper open source db be a big ask to add to the growing list of features?

Rennur

Why is it faster? Presumably because SQL Server database engine and/or JDBC driver are a lot more efficient than MySQL.

I agree the SQL Server is more secure, robust and probably faster. We will be looking to migrate to SQL Server as well & would love to hear from anyone that has done this.

The outdated version of the MySQL Connector/J from almost 9 years ago bundled with the installation probably degraded MySQL's performance.

I have a query displaying almost 10,000 records that loads in 2 seconds over LAN and about the same time over ADSL internet connection.

Just my 2¢

Cheers

kklosson

+1 for hearing from anyone who has made the migration. What was your process and what were youy results?

aware_support

Our customer did the following:

1) Purchased a tool called ESF Database Migration Toolkit (easyfrom.net) for around $200
2) Published blank BSV in SQL Server
3) Selected all tables to migrate in the tool. Selected "Append Data" option

His database of several Gb was transferred in a matter of seconds without any issues

Powerm

This is bad news for Mac and Linux users using MySql locally...

aware_support

Don't get me wrong - it's not that MySQL is slow. Not at all. It's just that SQL Server is faster.

ACDC

I would really like to try this out, but MS SQL pricing is just horrendous
🙁

RocketRod

Just use Express itsfree

ACDC

Express has its limitations, eg: memory usage max 1GB.

I suspect the better performance will be lost when the server reaches peak memory usage due to increased usage. Then you are forced to go to MS sql to maintain performance -and pay the big bucks

Rennur

Good points ACDC, we would only migrate to a full SQL server and not the express, but only when the performance with MySQL starts to noticeably suffer.

Gabbitas

Support,

On your website under pricing and additional features you have SQL Server listed at a cost of $1000. Please could you clarify what this additional cost is for? Is it an add on to enable AIM to work with SQL Server or are you actually selling a copy of SQL Server for a thousand bucks?

Thanks

kklosson

I can tell you for a fact that it's just for connecting AwareIM to a MS SQL Server Database.

aware_support

We are not selling a copy of the SQL Server. We are not allowed to do this. The $1000 option is for the ability to use the full version of SQL Server with Aware IM as a native database engine. SQL Server Express does not require this option.

Gabbitas

Ok. Thanks for the clarification.

ACDC

Wishfull thinking !

hpl123

Hi all,
A tip regarding SQL server. I got SQL server 2008 for free together with my Eukhost dedicated server and it could possible be worth checking out for those interested. www.eukhost.com

PS: I am very satisfied with eukhost by the way.