fast data search using java from oracle database

Asked Dec 16 '19 at 03:54

Active Feb 18 '20 at 19:57

Viewed 55 times

In an Oracle database I have like more than 178692 rows regarding to a store items. I need to develop regular web application using java and front-end will be plain html. is there any caching modular way to retrieve data from the front-end.

Bellow are my column headers and are all String of data type.

enterITM_DESC = *CHOCBOX WHITE CHOCOLA.BAR 50G,
ITEM_CODE=GRCO66760,
PLU_CODE =23270 code here

I need my searching functionality to be implemented item_desc and item_code will be the key for any instance. Your help matters a lot thanks in advance.

edited Feb 18 '20 at 19:57

Paulo Pedroso

3,555
2
29
34

asked Dec 16 '19 at 03:54

Gayashan

1

"178692 columns"? Do you mean rows? if not you have to re-think your table design. – seenukarthi Dec 16 '19 at 04:08
You will need indexes, unless you are meaning that you will show all 178692 rows. If so then see comment above. – Scary Wombat Dec 16 '19 at 04:10
Sorry I meant rows, I maintain indexes and will not output all the rows at once. I do not have an idea how index can help me to search an item by ITM_DESC – Gayashan Dec 16 '19 at 05:00
@Gayashan check https://stackoverflow.com/questions/1108/how-does-database-indexing-work – seenukarthi Dec 16 '19 at 06:29

fast data search using java from oracle database

0 Answers0