All Questions
5 questions
0
votes
1
answer
194
views
Is it more efficient to do SELECT and compare in Java or DELETE and INSERT
I am hitting a REST API to get data from a service. I transform this data and store it in a database. I will have to do this on some interval, 15 minutes, and then make sure this database has latest ...
1
vote
1
answer
708
views
JDBC prepared statement - make a token null
So, I have an insert statement in a Java program I'm writing. Under some conditions, I want it to insert some values as null. However, before I can execute the statement, I have to set all of the ...
3
votes
1
answer
409
views
What are possible causes for consistently volatile INSERT performance in MySQL tables?
I have a Java program running on a VM that is sequentially feeding a queue of single row INSERTs through a single connection to a MySQL server on the same VM. The queue execution is not artificially ...
- 273
11
votes
3
answers
15k
views
Insert Speeds for large batches
In my application, my INSERTs seem to be taking a major chunk of the time. I have a large number of objects in memory (~40-50,000) which i want to insert into a table.
Lets take a sample table
...
- 211
4
votes
1
answer
4k
views
Derby slows down after 1.2 million records
I'm using a Derby database, mass insertions slow down to 1/4 to 1/6 the speed once there are 1.2 million records (about 6 GB database size, one major table, other tables are tiny). Is that normal? Is ...
- 41