I have a query in regards to what is the best way of handling huge files in Java? Shall we use the no-sql database like Cassandra or try to use our existing Oracle database (to dump the content of the file).
My file can contain at most 1 or 2 fields. But mostly what I shall be able to do with the file content is just search an Id and return boolean. The file can contain records in tens of millions or as low as thousands. Also, this file can get refreshed on daily basis. Whenever refreshed I need to clear all previous values.
Any suggestions would be appreciated!!
General support questions
1 post • Page 1 of 1