Comments by Office Systems

Office Systems 15-Apr-24 5:20am View

Any suggestions here

Office Systems 8-Apr-24 5:58am View

I'm using Spring Boot version 3.2.3 and Tomcat version 10.1.19 @Pete O'Hanlon

Office Systems 24-Mar-24 5:54am View

Thanks so much @Andre Oosthuizen that is exactly what I was looking for much appreciated 👍

Office Systems 19-Mar-24 8:58am View

Thanks @Pete O'Hanlon for that response let me have a look on these ETL tools so that I can use them to lift data into postgreSQL data, thanks again in advance.

Office Systems 19-Mar-24 8:17am View

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.

Office Systems 11-Mar-24 4:49am View

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

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 27 by date)