PureBasic Forums - English

Hi , all! I have such a need for regular automatic testing of Internet speed (and I think not only for me).
Perhaps someone has implemented or knows how to implement reading speed data through a request
to the site speedtest.net. If you just execute such a piece of code, I don't find any useful ...

perhaps security setting on the mysql server ...

Well, from the server side, I installed it in the server settings file
my.ini with the string local-infile = 1
when I execute this command through the HeidiSQL utility, the data is successfully imported into the table
The script with the LOAD ...

[quote="mk-soft"]I think is a String, but I don't know UNICODE or UTF8


r1 = mysql_optionsv(mysql_handle, #MYSQL_OPT_LOCAL_INFILE, @"1")


So the mysql_optionsv function also succeeds. But DatabaseUpdate still doesn't execute the command (LOAD Data LOCAL INFILE 'c: \\ Proxy_Logs \\ test4.txt ...

Thank you very much for your answer. This helped me a lot in understanding the subject. But I need to set the OPT_LOCAL_INFILE parameter and as a result get the ability to upload large files to the database using the command LOAD Data LOCAL INFILE. I changed your code a bit in order to set MYSQL_OPT ...

To load a text file into the mariadb table, I need to run the command
LOAD Data LOCAL INFILE. But the LOCAL parameter must be explicitly enabled as with the server one,
so from the client side. Well, from the server side, I installed it in the server settings file
my.ini with the string local-infile ...

In this case, il will be faster to directly import data in database then drop unwanted datas.
LOAD DATA INFILE
The task came precisely to the fact that you need to import a large file into the database. For work with large data arrays, I chose Mariadb. I use the native mode of working with the ...

Marc56us wrote: In this case, il will be faster to directly import data in database then drop unwanted datas.
LOAD DATA INFILE

Thanks for that, I'll try

I understand that it is necessary to detail the conditions of the task. Often I have to get proxy log information from servers that I support. There are several hundred of them, and the sizes of daily logs vary from several hundred megabytes to several gigabytes and several billion lines. Each ...

@olmak: Let me get this straight. First you load the large file (up to 10 GB) into memory, then you copy the memory contents into a string, and then from the string into a string array? How much memory does your computer have?
Yes, exactly. The computer has 16 GB of RAM. And now I'm talking about ...

Sorry for the typo, I removed comments and something left. As I understand it, you are advised to process data in batches. I also thought about it, but I hoped that maybe there is some more elegant solution. In my case, the size of the String variable into which I copy the entire file from memory is ...

Hi. all! There is such a task - to read very large files (up to 10 GB) for further processing.
An array element is created for each line of the file.
After reading the forums I got such a fragment : Procedure ReadFileIntoArray(file$, Array StringArray.s(1), Separator.s = " ")
Define String.s ; The ...

Thank you very much, HeX0R!
I have replaced the old Code(1.50) with this module (1.51)
Error fixed

Thank you, Keya. Unfortunately I have very little programming in PureBasic, so I do not quite understand your advice. Can in more detail?
The code snippet in error

Case #REG_EXPAND_SZ
Debug *lpData ; I get number value
ExSZlength = ExpandEnvironmentStrings(*lpData, 0, 0) ; <-Error - Invalid ...

Hello at all
I'm trying to get a list of installed programs, with some parameters.

IncludeFile "Registry.pbi"
UseModule Registry
Define count, i
count = Registry::CountSubKeys(#HKEY_LOCAL_MACHINE, "SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall", #True)
For i = 0 To count - 1
Subkey ...