1. Tips on Speeding up JDBC writes? stackoverflow.comI am writing a program that does a lot of writes to a Postgres database. In a typical scenario I would be writing say 100,000 rows to a table that's ... |
2. efficient db operations stackoverflow.comHere is the scenario I am researching a solution for at work. We have a table in postgres which stores events happening on network. Currently the way it works is, rows ... |
3. java.sql.Connection tests against a PostgreSQL 8.4.6 stackoverflow.comI have a postgresql DB with > 3 million rows in two tables.
Something slows down the whole performance, so I analyzed a bit with the Ubuntu command |
4. Which is better? Performing calculations in sql or in your application stackoverflow.com
Let's say, I have the above table. I want to get the records for yesterday and
generate a report by having the amount printed ... |
5. Too many data type queries on creating persistent manager with datanucleus stackoverflow.comWe found the performance of connecting to a remote postgres database is very bad with datanucleus and postgresql jdbc. The reason is there are many queries generated to query the data ... |