Indexing in MySQL

I have been working a lot with JavaFX recently and it’s been a while since doing any SQL work. After loading my project and running a few test commands I was pretty shocked to see that the SELECT statements were taking almost 15 seconds to produce a response!...

Database Cleanup Part II

After spending a lot of time on this I failed. Well, I failed to do this how I wanted to. I wanted to create a loop of sort – set it off once, walk away and come back to an empty table. I tried numerous times. I’m not going to list all the code examples...

Database Cleanup

Work’s been busy, so I’m only just starting to get some time to continue writing my plugin – Medieval Realms for Rising World. Continuing on from my bulk INSERT code I was testing – which works fantastically. Although at the time of writing...

MySQL Performance Tests

I’m continuing to work on my Medieval Realms project and one of the obstacles I’m faced with at the moment is the storage and retrieval of large amounts of data. My initial test application which consists of approximately 410,000 data sets using a single...

Delete a Foreign Key if exists

I’m currently developing a new database, requiring the initialisation code to be run over and over again. Creating tables with IF EXISTS is easy. Delete a foreign key if one had been created already was a little more problematic. set @var=if((SELECT true FROM...

Todays MySQL Timestamp Learnings

Today I have decided to take a look at the redesign of the Medieval Realms database. This is the first production database I’ve ever written. It’s ugly. It’s not really relational. And it’s bloated to 34 tables. This database has grown...