Click here to Skip to main content
14,207,205 members
   

Java

 
GeneralRe: programation cloudsim java Pin
Eddy Vluggen19-May-19 8:58
mveEddy Vluggen19-May-19 8:58 
GeneralRe: programation cloudsim java Pin
Richard MacCutchan19-May-19 21:15
protectorRichard MacCutchan19-May-19 21:15 
AnswerRe: programation cloudsim java Pin
jschell23-May-19 5:35
memberjschell23-May-19 5:35 
GeneralRe: programation cloudsim java Pin
Eddy Vluggen23-May-19 23:36
mveEddy Vluggen23-May-19 23:36 
GeneralMessage Closed Pin
6-May-19 2:36
memberMember 143572546-May-19 2:36 
QuestionMessage Closed Pin
2-May-19 0:27
memberMember 123216632-May-19 0:27 
QuestionWhat database shoud i pick for my java app? Pin
Member 1413007929-Apr-19 7:42
memberMember 1413007929-Apr-19 7:42 
AnswerRe: What database shoud i pick for my java app? Pin
Maciej Los29-Apr-19 9:16
protectorMaciej Los29-Apr-19 9:16 
Both databases (MySQL and PostgreSQL) are very well known and have almost the same functionality. As to performance - it's opinion based only Wink | ;) Joking! The thruth is that the performance depends on many factors, such as:
Quote:
  • You are not running with a transaction log (see "The transaction log"). A transaction log improves commit time for transactions that insert, update, or delete rows.
  • You are using the 16-bit version of the Windows 3.x database engine. The 32-bit version has better performance, especially for larger databases.
  • You are loading huge amounts of data into a database. See "Tuning bulk operations" for methods to improve performance.
  • The database engine does not have an adequate amount of memory for caching database pages. See "The database engine" for command line options for controlling the cache size. Extra memory for your computer could improve database performance dramatically.
  • Your hard disk is excessively fragmented. This becomes more important as your database increases in size. The DOS and Windows database engines cannot do direct (fast) reading and writing when the database file is very fragmented. There are several utilities available for DOS and Windows to defragment your hard disk. One of these should be run periodically. You could put the database on a DOS disk partition by itself to eliminate fragmentation problems.
  • You are using a small page size for a large database. The page size is determined when the database is created by the initialization utility. You can find out the page size by using DBINFO. To change page size, you need to unload and reload your database.
  • The database table design is not good. A bad database design can result in time-consuming queries to get information from the database. If indexes will not solve your performance problem, consider alternative database designs.
  • Your hard disk is slow. A faster hard disk, a caching disk controller or a disk array can improve performance considerably.
  • In a multiuser environment, your network performance is slow.
  • You are fetching or inserting many rows of data. Consider using the multi-row operations.


See:
Comparison of relational database management systems - Wikipedia
DB-Engines Ranking - popularity ranking of database management systems
SQLite vs MySQL vs PostgreSQL: A Comparison Of Relational Database Management Systems | DigitalOcean
Factors affecting database performance

So, decision belongs to you... Smile | :)

Good luck!

modified 29-Apr-19 15:29pm.

GeneralRe: What database shoud i pick for my java app? Pin
Member 1413007929-Apr-19 10:02
memberMember 1413007929-Apr-19 10:02 
GeneralRe: What database shoud i pick for my java app? Pin
Maciej Los29-Apr-19 10:11
protectorMaciej Los29-Apr-19 10:11 
AnswerRe: What database shoud i pick for my java app? Pin
Gerry Schmitz29-Apr-19 15:23
mveGerry Schmitz29-Apr-19 15:23 
GeneralRe: What database shoud i pick for my java app? Pin
Richard MacCutchan29-Apr-19 21:16
protectorRichard MacCutchan29-Apr-19 21:16 
GeneralRe: What database shoud i pick for my java app? Pin
Dr.Walt Fair, PE5-May-19 7:42
professionalDr.Walt Fair, PE5-May-19 7:42 
AnswerMessage Closed Pin
1-May-19 4:52
memberMember 143515841-May-19 4:52 
AnswerRe: What database shoud i pick for my java app? Pin
Kelly Ferguson19-May-19 22:57
memberKelly Ferguson19-May-19 22:57 
QuestionHow to add JMenu Pin
Member 1431822321-Apr-19 0:57
memberMember 1431822321-Apr-19 0:57 
AnswerRe: How to add JMenu Pin
Richard MacCutchan21-Apr-19 22:21
protectorRichard MacCutchan21-Apr-19 22:21 
Questionspeech recognition project in java for controlling your pc using voice java Pin
Member 1422299418-Apr-19 23:56
memberMember 1422299418-Apr-19 23:56 
AnswerRe: speech recognition project in java for controlling your pc using voice java Pin
Richard MacCutchan19-Apr-19 0:34
protectorRichard MacCutchan19-Apr-19 0:34 
Questiong.drawString is not printing the correct value in Jpanel. Pin
chandra12212-Apr-19 5:01
memberchandra12212-Apr-19 5:01 
QuestionRe: g.drawString is not printing the correct value in Jpanel. Pin
Richard MacCutchan12-Apr-19 6:19
protectorRichard MacCutchan12-Apr-19 6:19 
AnswerRe: g.drawString is not printing the correct value in Jpanel. Pin
chandra12212-Apr-19 18:58
memberchandra12212-Apr-19 18:58 
GeneralRe: g.drawString is not printing the correct value in Jpanel. Pin
Richard MacCutchan12-Apr-19 20:51
protectorRichard MacCutchan12-Apr-19 20:51 
GeneralRe: g.drawString is not printing the correct value in Jpanel. Pin
chandra12212-Apr-19 22:57
memberchandra12212-Apr-19 22:57 
GeneralRe: g.drawString is not printing the correct value in Jpanel. Pin
Richard MacCutchan12-Apr-19 23:23
protectorRichard MacCutchan12-Apr-19 23:23 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Cookies | Terms of Service
Web01 | 2.8.190612.1 | Last Updated 14 Jun 2019
Copyright © CodeProject, 1999-2019
All Rights Reserved.
Layout: fixed | fluid