Newbie Question - MySQL vs Derby

If you have questions or if you want to share your opinion about Aware IM post your message on this forum
Post Reply
johnaohman
Posts: 10
Joined: Wed Oct 24, 2007 10:37 am
Location: Woodstock, GA

Newbie Question - MySQL vs Derby

Post by johnaohman »

Sorry for the elementary question - but what better way to learn .. ..

I know AwareIM comes with IBM Derby as a database, and I also know that you can install AwareIM and have it use MySQL instead if you configure it properly.

The question I have is what is the relative advantage of using MySQL vs Derby. It seems that MySQL is "all the rage" in many internet applications and I'm just not sure what advantages is brings as the backend for AwareIM as opposed to Derby? :?:
Regards,

John Ohman
Top
tford
Posts: 4238
Joined: Sat Mar 10, 2007 6:44 pm

Post by tford »

John,

One small but significant advantage to MySql has to do with searches.

MySql does searches that are NOT case sensitive while Derby IS case senstitive.

Tom
Top
aware_support2
Posts: 595
Joined: Sun Apr 24, 2005 2:22 am
Contact:
Contact aware_support2

Post by aware_support2 »

This subject has been discussed a few times on this forum. You can do a search on it.
Aware IM Support Team
Top
Post Reply

Return to “General discussion and questions about Aware IM”