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!...

Convert Milliseconds to Weeks, Days, Hours, Minutes, Seconds

Some basic math to calculate Weeks, Days, Hours, Minutes, and Seconds from a given time in milliseconds. Super useful for process timing. public String getElapsedTimeString(long milliseconds){ int seconds = (int) (milliseconds / 1000) % 60 ; int minutes = (int)...

Unity Day

It’s the Thursday before the bank holiday. No work booked in for today and I’m all up to date on client projects. This sounds like a method call for – Unity Day! I can’t believe it’s been two years since I created Cubes Version 1.0 After...

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...