I'm trying to filter through millions of documents. Each document is about 7kB in size. For the moment, I'm filtering on a maximum of 8 (defined) fields, but more will be added later. Filters can be anything, like : "field":…
I tried $obj = [System.IO.File]::ReadLines((Convert-Path -LiteralPath names.json)) | ConvertFrom-Json $keys = @() foreach ($key in $obj.GetEnumerator()) { $keys += $key.Key } Write-Output $keys But after over 24 hours it had not completed. I need the key names so I can…
I have a fairly large dataset (~50K entries) which I use to generate a correlation matrix. This works well, using "only" ~20GB RAM. Then, I want to extract only the unique pairwise combinations from it and convert it into a…
I have 2 big tables in my database (wp_frm_items with about 3 million rows and wp_frm_item_metas with about 35 million rows). I'm using the Query Monitor WordPress plugin and noticed that queries using joins and making counts are slow. Some…
i am using a mysql database version 5. I have a table, that has about 500.000.000 rows.The table reclaims 50GB of diskspace if i trust phpmyadmin. I like to delete 90% of the rows to reclaim disk space. What is…
I have a database named db_x on server X (running WHM) and another database named db_y on server Y. I connected to server X via SSH made some changes to the phpmyadmin configurations to allow it to connect to db_y…