Posts by Bruno Silva • 71 points
11 posts
-
-2
votes1
answer42
viewsQ: Different performance using limit less than 100 and greater than 100
I have a subselect that filters 16 records and there is a limit of 100. This consultation results in a time usually of 1:20 ~ 1:40 minutes. But when I change the limit to a number greater than 100,…
-
0
votes2
answers479
viewsA: Delphi Twebbrowser Validate Recaptcha
Currently there are services that provide the captcha solution, usually charge for each solution. If you inspect the page you will see that just below the reCaptcha there is a tag called…
-
3
votes1
answer88
viewsQ: Is there any SVN for database?
I have the following environment, an online database (Mysql) for production and several others (copies for each developer) used for local testing. Is there any program as well as SVN that performs…
-
0
votes1
answer475
viewsA: What is the best way to clear your memory when using Lkjson in Delphi?
I ended up finding a problem in my code. There was a line where when there was no record in the database, the object was created and was not linked to the parent object, consequently it could not be…
-
1
votes1
answer475
viewsQ: What is the best way to clear your memory when using Lkjson in Delphi?
I’m having trouble wiping the memory data when I use Lkjson in Delphi. I tested using Freeandnil, Free, Destroy and Freeinstance. In some cases I get the following message when closing the…
-
0
votes1
answer483
viewsQ: How to return data from a thread to the runtime layout in flutter
There is how to thread using the flutter and return the processing result on the screen? I have the following code. In the main class _Myhomepagestate I have the layout and function _process(). The…
-
0
votes0
answers184
viewsQ: Problems running Mysql function using Delphi Firedac 10.1
In a Mysql database I have a function (not Procedure) fully functional, I can access normally within heidisql. At Delphi, I’ll tell you what function ExecutarFuncaoSQL(sFuncao: string; aParams:…
-
0
votes1
answer122
viewsA: How to use Mongodb 'Regex' filter in PHP
I was able to solve it this way; $regex = new MongoDB\BSON\Regex(trim('123456789', '/'), 'i'); $search = array('doc.Documento.@Id' => $regex); $options = [ "skip" => 0, "limit" => 10,…
-
-1
votes1
answer122
viewsQ: How to use Mongodb 'Regex' filter in PHP
I have made some attempts following examples on the internet, I found some until there seems to be a mix of the two versions of the driver Currently, in the Mongodb bank I have a structure similar…
-
1
votes1
answer647
viewsQ: How to insert equal objects or list of objects in Mongodb?
Example, I have the following JSON: { Casa:'b32', integrantes:{ pessoa: 'joao', pessoa: 'Maria', pessoa: 'Daniel' } } When you enter it into the database it looks like this. Apparently it is…
-
1
votes1
answer439
viewsQ: How to return an object from a bank in QTL(Mongodb)?
I currently have some objects in a Mongodb database. The structure is as follows. { "_id" : ObjectId("55cb9c666c522cafdb053a68"), "geometry" : { "type" : "Polygon", "coordinates" : [ [ […