performance « Database « Java Database Q&A





1. Highest Performance Database in Java    stackoverflow.com

I need ideas to implement a (really) high performance in-memory Database/Storage Mechanism in Java. In the range of storing 20,000+ java objects, updated every 5 or so seconds.
Some options ...

2. jdbc performance testing for getting CLOB/BLOB data    stackoverflow.com

I am trying to compare the performance of the different calls (getBytes/getBinary/getBlob) for getting data out of a BLOB column. What I am doing right now is tracking the time to ...

3. How would I go about making an efficient key value store (e.g. memcache) / simple database?    stackoverflow.com

For a few projects I'm working on I need a persistent key value store (something akin to memcache). It would ideally run as a server; it needs to be really efficient. ...

4. Best Design for the scenario    stackoverflow.com

I have a requirement where I have to select around 60 million plus records from database. Once I have all records in ResultSet then I have to formate some columns as ...

5. Java EJB entity beans performance    stackoverflow.com

How performant is the entity bean? Would it be too much to ask if I want 1000 objects per table (probably about 20 tables) across 5 processes where some processes might ...

6. When to 'IN' and when not to?    stackoverflow.com

Let's presume that you are writing an application for a retail store chain. So, you would design your object model such that you would define 'Store' as the core business object ...

7. Performance: Java vs. Database    stackoverflow.com

When programming there are decisions to make all the time, like:

  • Should I generate my Menu/Buttons/Navigation dynamically from a db entry or static via code
  • Should I count entries of a list by ...

8. which keyvalue store has the best performance?    stackoverflow.com

I think tow months ago. I found a google's open source project that can store key value pairs with high performance. But i forget the name. Could anybody tell me? or ...

9. How efficient will be to use a in memory database to store millions of temporary values?    stackoverflow.com

My application currently stores millions of Double elements for a calculation. These values are only temporary values before they are used for a specific algorithm that is run at the end ...





10. NoSql Battle - Survivors?    stackoverflow.com

GraphDB vs Key-ValueDb's Neo4j versus OrientDB Valdemort versus OrientKV Features to choice and compare

  • Easy to install (no dependencies, just place/extract on folder)
  • Performance and scalability
  • small footprint
  • good documentation (tutorials and examples)
  • administration facilities, monitoring tools
  • low learning ...

11. java duplicate entry and performance issue    stackoverflow.com

What Lang: Java + MySql What I have: I have a data class that stores (id, firstName, lastName, workingHours). I fetch this information from database and store in data class. This data class contains ...

12. Edit several hundred Protocol Buffer serialized messages read from database    stackoverflow.com

For an operation on my application, I need to read from database & then edit several hundred Protocol Buffer serialized messages. In each PB message, there are actually 4 int fields ...

13. Does it necessary to enable the "keepalive" in the JTDS for the performance increase?    stackoverflow.com

How much will performance increase when enabled the config of "keepalive" in JTDS? I reviewed the jtds document today and found one interesting config "sockekeepalive" never noticed before. And ...

14. What DBMS would fit this requirements best? (Big, Simple Structue, Massive Write / Fast Read, Java)    stackoverflow.com

I need a database that can store a massive amount of simple structured data and make it available relatively fast. The use-case is quite simple, so I will explain it in a ...

15. Database Tuning for Performance    coderanch.com

Hello all, I am having an insert query which inserts 5000 records one by one in the database table.So it takes lots of time.So i just wanted to know that if i can do this some other way so that all 5000 records can be inserted at one go rarther than 5000 insert statements which doesnt take time. Another alternate approach ...

16. Performance problem in database application    coderanch.com

Hi, I have an web application which does differnt types of searches based on queries. In the application there is hyperlink based queries and custom search queries form also. The search query is running on a view. This view build from two tables. The main table haviing around 5lakh records and other table contains around 8lakhs records. So once the user ...





17. Performance Improvement in Database Operations- my 5 cents    coderanch.com

Hey All, Just wanted to share my experiences in achieving a better performance for database operations. My days have been getting better from the day I started passing/retrieving Arrays to my oracle stored procedure. Loads of data are getting transferred either way in a matter of fractions of milliseconds. Before using Arrays we used to call our stored procs in a ...

18. Performance of fomatting string : Java vs Database.    coderanch.com

A somewhat unrelated side issue is that JDBC is a string-based API anyway. Any data will be sent to the database as a string, not as (e.g.) a date. So if the formatting were done in the DB, then the date would be formatted to a string by JDBC, then sent to the DB, and then be re-formatted according to your ...

19. Optimizing sevlet performance with a database    coderanch.com

Hello I have a design question. Where is the best location on a servlet to access a database (assume a connection pool exists), and is database activity optimal when synchronized or left alone, for a high volume site? When I say location on a servlet I mean, is it best to just write it in the service methods? Or Is it ...

20. Db calls & performance    coderanch.com

That's true, you should find the bottle neck and then resolve it rather than coming up with predictions. Most of the time, the performance hit is from slow running SQL statements rather than the way JDBC is written. It won't be useful to optimize JDBC code if a query takes 10 seconds to run on the DBMS side. Some JDBC performance ...

21. Performance of fomatting string : Java vs Database.    forums.oracle.com

I have a String which needs be sent to a stored procedure. Then this string is inserted in the database through the stored procedure. But the string needs to be formatted (say date formatting). This formatting can be done either in the java program which later calls the stored procedure or in the stored procedure itself. Which way gives better performance? ...

22. Performance problems while saving a lot of data in DB    forums.oracle.com

Hi guys, I have problems concerning performance of data publication process . That is, initially I have a huge array of objects. Each object has approximately 20-25 fields and there are 50,000-1,000,000 such objects in the array. I call (through iBatis) a stored procedure (it's Oracle RDBMS 10.3) to save the data to the database (it will be modified slightly before ...