CODEWITHSUNDEEP
relational-databasederby
Mike Warren
Mike Warren

Reputation: 3866

Do Derby databases have a limit

Does a derby database have a limit to how many times you can query it (over its lifetime)? I know that a Derby database stores the transactions made on it so that ROLLBACK can be called and restore the database to a previous state. However, the question still exists on whether this would limit the number of queries/changes made

Upvotes: 1

Views: 284

Answers (1)

Dyre Tjeldvoll
Dyre Tjeldvoll

Reputation: 59

Short answer is no. Slightly longer answer: You can only rollback transactions that have not yet committed. The number of uncommitted transactions you can have is only limited by the size of the log which is only limited by your file system.

Of course, testing the limits of software in this way is usually not a good idea, and with lots of uncommitted transactions you risk losing a lot of data in the event of a crash (software or hardware). Best practice is to commit transactions as soon as you can as this will make your system more robust, perform better and reduce contention (an open transaction holds locks on elements of your db which will put restrictions on concurrent access).

Upvotes: 2

Related Questions