Comments by Office Systems (Top 28 by date)

Thanks @OriginalGriff for your detailed explanation however the list that I want to dump it into PostgresQL is large and due to its processing from the server side application which is spring boot this is where the problem starts if the amount of data is reducing then the application works fine and it just takes miliseconds but when the amount of data increases this is where the things gets a little bit complicated so I was trying to figure it around if there is a means of copying the whole data from the list and dump them at once even the process will take a minute but they will have to be inserted.

Thanks so much @Pete O'Hanlon this works fine 👍

Thanks so much @Gerry Schmitz the idea seems to work, much appreciated 👍

Thanks so much @Member15627495 for your quick response however I'm so sorry for asking this can you please try to explain it in a more simple way so that I can get more clarification on how I can implement proper mechanism to handle the scenario.

I just want to count the results I can't return such data to the user there is no means I can count these values depending on these conditions provided @Richard MacCutchan?

The query returns more than 4 million rows @Gerry Schmitz

The cors headers are configured by the spring boot project not the frontend app or calling site @Richard Deeming

Thanks alot @Gerry Schmitz for your suggestion using the Native SQL has reduced time up to 33 seconds which is somehow perfect as the way I wanted, thanks so much I really appreciate.

I'm using PostgreSQL as the backend database and 1000k records are left after deleting these records with that particular orderCode Id @Gerry Schmitz

yah sure @Richard MacCutchan but is there any means I can optimize the query to reduce this time at least to 30 seconds up to completion.

No its not chunking @Gerry Schmitz

Thanks Dave, I appreciate.

Thanks so much @Dave Kreskowiak for your response, how can I index my status field which has string values so as I can improve performance?

The values are stored in database tables as Strings

2 represents the month which is february

This is done 👍

I tried that approach last week but it didn't seem to work that's why i decided to delete them all and do a fresh insert

Thanks @Richard MacCutchan can you please describe it a little bit more by using example

Thanks so much @Andre Oosthuizen that worked perfect👍

Ok Richard let me try out and then post the question with full information thank you.

Thanks Richard for your response can I share with you my project on github and help me to figure it out?

for (Customer customerData: dbData) {

if(customerData.getOrderDate().equals(result.getString(2)) == true) {
System.out.println("Data Present In Database");
}else {
System.out.println("Data Absent In Database");
}

It prints only "Data Present In Database"

May be I should put it a little bit more clear @Andre Oosthuizen my concern is I want to update if the data is present within my database and Insert a new record if it does not exist, now the issue I'm facing is that data present inside database are updated correctly but these absent are not inserted and I can't even get them within the if else statement and at the debugger meaning new records are not fetched by the query