S
Stefan Marquardt
Guest
Are you looking at overall record reads? Or reads shown in "table activity"? I am looking at Table Activity, read with table-scan has the double value than create. Over the night I got the idea that it could be normal because the index read replacement is now moved to the table itself, but this is a little bit confusing because you need to know that reads are twice for some programs using table-scan. Otherwise you are wondering about more reads than you have records in it. For chunking: I am nut sure but I know that the code was working fast, then I tried to delete the table with an index to analyze speed and since it's slow. Sounds crazy, I know ... BTW: How nice it would be to get a full lock on a table, especially for aggregation tables, do run something like a CLEAN table command instead of waiting for deleting row by row. But this was discussed so often without a good solution.
Continue reading...
Continue reading...