Gardenscape update taking to long9/25/2023 ![]() Many thanks on advance and excuse the broken english. Has anyone had any issue like this? I've googled intensely but I can't find any valid solution. The last one update get the local time on a date col, and takes more than 1 hour. I also have tried to put an unique key, launching statistics, using NOLOGGING tables + APPEND hint, but I can't see any improvement. Strangest thing is that the first col to update (number 36) takes like 1 minute to complete, the second (37) takes a bit more, and the last one take like 15 minutes to finish the update. It's a simple UPDATE TABLE_A SET COL = 0, but it takes more time that the update with the where clause. ![]() I've tried a few things, like trying to update all rows to 0 and after that launching the update which marks right data. Well, the second update takes too much time, imo, being a simple update (UPDATE TABLE_A SET COL = 0 WHERE COL 1). The second one marks to 0 all data which doesn't match. The first one updates to 1 if the condition matches some where clauses. On the last 18 cols, which are NUMBER, I run 2 updates on each one. You can also adjust your device settings to automatically download updates for the apps you have installed: 1. Find the game name in the list and tap it. The problem is that I have a table with 1.200.000 rows, and 53 columns. Tap the Menu icon in the top left corner, and then My applications and games. I'm working on a some kind of BI data processing and right now I'm trying to improve the time needed to process the whole data.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |