Attila Kovacs

It's called "Deferred LOB Read" and supported for example by UniDAC.

I would locate the problematic tables and outsource them into a decent DBMS and rewrite the affected parts using 2 concurrent connections to get some peace for the first time. Then I'd not touch it for the next decade.

Cool. Is it possible that you have a recursion in your search dir tree? Like for example "Users\xxxxx\AppData\Local\Application Data" points to "Users\xxxxx\AppData\Local".

Hahaha, that's why I can't reproduce 😄 Thx for jumping in 😉

@Stéphane Wierzbicki Are those 3.6M entrys all these kind of items? Name not found? Are they recurring? Do you have this CPU load on a "real" fresh install too?

@Stefan Glienke Can't reproduce. But instead of removing something from the path I've switched to x64 where several things are missing.

I understand but please tell me how can I get a page full of "name not found" in procmon? I've it running, what should I do?

Where? In c:\vcl? How is the IDE such smart?

Maybe I need glasses, it's desired access not denied, but this doesn't explain why are you telling us "fresh install" and why can't bds find anything.

Am I the only one who's disturbed seeing a Procmon screenshot with a bunch of NAME NOT FOUND / DENIED ACCESS on C:\VCL etc... directories which are not part of a freshly installed IDE? For what did you start it anyway if you are ignoring the output?

@Uwe Raabe Yes, but no, it does not fit to the shown example.

@Uwe Raabe Or one could just assign the local variable back to its origin. Should work from D1.

*Read: The code used to work by accident.

Turn off theming and dump moderntheme260.bpl and re-check. (Alternatively you could disable the compile dialog)

@PeterPanettone Maybe your misunderstanding? This is the Navigation toolbar: Not ok?

Hi, Can we have a sub for OTA/Expert development? As for pro's as for hobbyists, for asking for help, sharing ideas, etc.. Greets

There must be space on the TEditorNavigationToolbar for that. On the same analogy I put the standard IDE form editing toolbars to the top of the FormDesigner. Where it actually belongs to.

Did you solve it John? Looks similar to this:

Strange. Also, on a fresh windows, Rio installer creates a ...BDS\19.0 registry entry too. It's empty, but this means they have places where the path is still from tokyo.

did you install delphi for all users or for one user? what if you start it as administrator? There are a lot of access denied entrys.

I'm not sure what are you asking and how should we help blindfolded, but I would do these in first place: move your declarations out to a separate unit if you can, if not, move it somewhere else inside the current unit and check if the same AV raises (eventually declare dummy vars between the arrays) turn on range and overflow checking (1..100 could be tricky) check your class destructors if you have, they are processed at finalization place a breakpoint at the "end." in your dpr and start stepping through and try to understand what happens

@Dmitry Arefiev Since you are already here, do you have any Sql Server Schema/Data sync tool in your drawer?

ORDER BY x,y,z OFFSET 19900 ROWS FETCH NEXT 100 ROWS ONLY It's also new for me so I don't know the caveats, but it looks interesting/promising. Sql Server 2012+

Ok, looks like the coder used this trick to trim the trailing zeroes but didn't count with empty/short headers.

I like winapi. There you can get real knowhow by bruteforcing it.