All Questions
7 questions
2
votes
1
answer
559
views
Generating and storing a unique salt in Oracle database using Java
This is my account table:
...
- 143
3
votes
2
answers
212
views
Program for entering 1000 random numbers into two different databases, one for odd numbers and one for even
I have created a program in java for entering 1000 random numbers into two different database one for odd numbers and one for even. The code is executing fine but it takes nearly a minute to execute. ...
- 31
1
vote
1
answer
381
views
Slow delete query on table with composite index
after profiling my application, it turns out that a single method is taking 3 minutes to run, which is about a third of the total runtime.
The method deletes approx. 400.000 rows from each table (<...
- 313
3
votes
1
answer
133
views
Loading, computation and writing 500.000 rows in database
first let me explain what I am trying to achieve here :
I am supposed to compute some results, using data from several tables, filtered by a run_id.
One of these tables has about 500.000 rows per ...
- 313
4
votes
1
answer
1k
views
Optimize MySQL in a stored procedure
How should I optimize my code for better performance? When I execute the code outside of MySQL stored proc, it is 500% faster.
MySQL stored procedure
...
- 348
3
votes
2
answers
150
views
Adding a list of brokers to a local SQLite database
I have this piece of Java (Android) code that adds a list of brokers to a local SQLite database as one single SQL instruction.
...
- 33
1
vote
2
answers
466
views
How to optimize this SQL delete
I want to optimize the performance of this SQL query. If I populate this hashtable with one million keys the query will take around minute. How I can optimize this Java method for faster execution?
<...
- 145