Attila Kovacs

You are mostly benchmarking stack operations, calls etc.. -again- everything which has nothing to do with the actual comparisons and it's asm implementations. I'd suggest you to buy an assembly book first and try to understand the asm in the Delphi debugger. There are 3 changes in the unit, try to find them and tell us what do you think about the new results. Project1.dpr

I have an app which downloads table data's from a server with CleverComponents + OmniThreadLibrary. Data is json, zipped, encoded. All CPU is used for downloading and importing the data into an SQL server. Here are some results with FastMM 4 (default) vs. 5 using Berlin U2. 32bit FastMM4 Sync done in 138,29 Sec 32bit FastMM5 Sync done in 106,903 Sec 64bit FastMM4 Sync done in 144,357 Sec 64bit FastMM5 Sync done in 107,587 Sec I was shocked by these numbers so I thought I'm sharing my experience.

I'd bet your program saved it at the end without the full path, so you just have copied the right one to the right place ?

Or you can run it as a standalone application as well, sharing the units.

I don't think that attaching 3rd party processes is the official way to debug isapi or other services. Is it?

for sure not just because of the numbers

Maybe you could hire a programmer to make that, what is your budget?

This is pretty true for everything in life. This is all made up, there is no need to mix anything, there should be rules to follow and that's it. I'd also find the problem in a very short time. Also, where would you store all the opened non-modal forms and why would you do that in first place? Let me guess, are those "big, complex projects" which are full of cross-form references? Form2.Edit.Text := 'lala'?

Haha, thx Dany, I have to admit I'm really busy with other things these days and also, his avatar mesmerizes me all the time I'm seeing it. But I'll keep an eye on him from now on 😄

there is no problem with that pattern and there is no simpler pattern and it introduces no unnecessary dependencies

Ahh, it's you again, emailx45 the warez king and comic book flooder. <o>

The original PDF has -who know how much- more pages so it's not on the page 71, as I said, it's almost impossible to find his reference after making a slapstick comedy from that document.

It's hard to find that reference after you made 100 new editions without any official source.

@joaodanet2018 I have the strong suspicion that you are pasting into this forum -in some uniquely ugly way- everything you can google up. Why?

So it's working as expected?

What do you want to say with that?

#define WM_UAHDESTROYWINDOW 0x0090 // handled by DefWindowProc and the comment should give some hint why are there different messages

I'd be surprised if FILE_FLAG_SEQUENTIAL_SCAN would give any notable boost.

Not sure? That's interesting, you could save 150 secs and a bunch of coding but you are don't bother to find out? double double quotes are escaped double quotes but you can go the explicit way: FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY ''

No, I didn't say no conversation, I said LOAD DATA can be told what to do. So either I'm still missing something or you did not check the help on LOAD DATA? LOAD DATA INFILE '/path/to/temp_test.csv' IGNORE INTO TABLE temp_test FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n' -- or '\n' IGNORE 1 LINES (@c1, @c2) SET c1 = STR_TO_DATE(@c1,'%d-%b-%y %H:%i:%s') ,SET c2 = (@c2 = 'True');

I would not do that to myself but I'm a lazy dog. However, I'm not sure if we should ignore the original problem, LOAD DATA not want to have double quotes or wrong date format etc... because AFAIR it can be told both.

I understand now. And why would their disks write faster from a different thread? More pressure? 😉 By the way, you can tell load data to handle double quotes and stuff.

How often do you have to import that file?

why do you need writefile more than once? how much gigabytes is that csv?