MySQL SELECT statement in-clause vs. JOIN

I created an application to build up a world for my latest project (a browsergame). For this I need to update about 25.000.000 records within my database. I realised my algorithm for updating those records was useless as more and more records were worked over. So I thought about dropping those records out, that were… MySQL SELECT statement in-clause vs. JOIN weiterlesen

Using a MySQL Database with C# in a multi-threaded application

A few days ago I was searching the internet for a solution to a problem, that was discussed often, but with no really working solution. Basically I worked on a small Visual C# program to update a certain table within a certain MySQL database. As there are millions of rows to select and update I… Using a MySQL Database with C# in a multi-threaded application weiterlesen