by Yahwho | Oct 11, 2022 | SQL
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!...
by Yahwho | Feb 2, 2022 | SQL
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...
by Yahwho | Jan 30, 2022 | SQL
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...
by Yahwho | Nov 30, 2021 | Java, SQL
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...
by Yahwho | Dec 19, 2020 | SQL
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...
by Yahwho | Nov 21, 2020 | SQL
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...