You seem to be missing the parameters that are to be inserted. See the examples at http://justinpdavis.blogspot.com/2010/04/logging-to-database-with-nlog.html The nLog web page doesn’t make it very clear that these are required, but if you squint your eyes and read https://github.com/nlog/NLog/wiki/Database-target you should find that they are required.
Another solution is to precreate 100 rows and instead of INSERT use UPDATE to update the oldest row. Assuming that the table has a datetime field, the query UPDATE … WHERE datetime = (SELECT min(datetime) FROM logtable) can do the job. Edit: display the last 100 entries SELECT * FROM logtable ORDER BY datetime DESC … Read more
Just split your userid from behind. e.g. UserID = 6435624 Path = /images/24/56/6435624 As for the backup you could use MySQL Replication and backup the slave database to avoid problems (e.g. locks) while backuping.
MySQL allows comments on tables and rows. PostgreSQL does as well. From other answers, Oracle and MSSQL have comments too. For me, a combination of UML diagram for a quick refresher on field names, types, and constraints, and an external document (TeX, but could be any format) with extended description of everything database-related – special … Read more
I always wrap a transaction in a using statement. using(IDbTransaction transaction ) { // logic goes here. transaction.Commit(); } Once the transaction moves out of scope, it is disposed. If the transaction is still active, it is rolled back. This behaviour fail-safes you from accidentally locking out the database. Even if an unhandled exception is … Read more
With a pooled data source, the connections in the pool are not actually closed, they just get returned to the pool. However, when the application is shut down, those connections to the database should be properly and actually closed, which is where the final cleanup comes in. Incidentally, the c3p0 project is pretty much dead … Read more
1) As far as I know, World of Warcraft runs on Oracle RDBMS. Not sure about the implementation details, however, it seems that low priority data (like the location of a character, attribute status etc) gets dumped into database in intervals and high priority data (level, item transfer) occurs real time (hence the noticeable delay … Read more
I suggest you read this page and watch the attached video. The Oracle Performance Group demonstrates how an application with a pool of 96 connection easily handles 10,000 front-end users and 20,000 transactions per-second. PostgreSQL recommends a formula of: connections = ((core_count * 2) + effective_spindle_count) Where core_count is CPU cores, and effective_spindle_count is the … Read more
While jOOQ and Hibernate compete for the same target audience, they do not solve the same problem at all. You’ve already linked this article in your question. The essence of it is simple: Are you going to solve object graph persistence problems? Use an ORM (e.g. Hibernate) Are you going to embed SQL into Java? … Read more