Comments by Office Systems

Office Systems 27-Oct-23 5:02am View

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

Office Systems 26-Oct-23 5:10am View

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.

Office Systems 26-Jun-23 14:37pm View

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?

Office Systems 26-Jun-23 12:49pm View

The query returns more than 4 million rows @Gerry Schmitz

Office Systems 18-May-23 8:28am View

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

Office Systems 26-Apr-23 13:11pm View

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.

Office Systems 26-Apr-23 10:44am View

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

Office Systems 26-Apr-23 10:36am View

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.

Office Systems 21-Apr-23 7:49am View

No its not chunking @Gerry Schmitz

Office Systems 21-Mar-23 10:24am View

Thanks Dave, I appreciate.

Office Systems 21-Mar-23 10:19am View

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?

Office Systems 13-Mar-23 13:47pm View

The values are stored in database tables as Strings

Office Systems 13-Mar-23 12:29pm View

2 represents the month which is february

Office Systems 19-Jan-23 6:56am View

This is done 👍

Office Systems 19-Jan-23 6:51am View

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

Office Systems 19-Jan-23 6:18am View

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

Office Systems 17-Jan-23 6:11am View

Thanks so much @Andre Oosthuizen that worked perfect👍

Office Systems 16-Jan-23 5:02am View

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

Office Systems 16-Jan-23 4:46am View

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

Office Systems 16-Jan-23 4:34am View

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"

Office Systems 16-Jan-23 4:22am View

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

Comments by Office Systems (Top 21 by date)