Evening All, At by absolute wits end and hoping someone may be able to save me! I am in the process of migrating a number of PHP applications into Azure. I am using: Linux based App Service running PHP 7.4…
I have a table with several million rows of data. I have a primary key on id, and a compound unique key on col2, col3, col4 and my_date (called comp_indx). Sample data is shown here... id col2 col3 col4 my_date…
Previously I had a post about a query that loads very long due to queries. I was advised to use microtime() to check the parts which loads long. Unfortunately, I was not able to find any problem since everything is…
Title says it all. I have a big array A of type unsigned int that I want to copy to an array Bof type char. I am not sure, if it might be beneficial for performance, if B was of…
I have a MySQL database table with 15 columns. It has 2 indexes; a primary which is an int (auto increment), and a compound unique index across 4 columns, int, int, int and datetime. The table currently has 5.5M entries,…
I have two arrays in JavaScript, and I want to create a new array that contains only the unique values from both arrays. How can I do this in JavaScript? const arr1 = ['apple', 'banana', 'cherry', 'date', 'elderberry']; const arr2…
Hi I have a database with 10 tables. each table has ~0.5-1 billion rows, and partitioned by range and then hash (10x10=100 partitions). they are newly created tables, and import data from csv files. they are indexed on the column…
I'm using laravel framework and now I'm thinking that if laravel resource reduce the performance? Because it at first select all columns (select * from TABLE) then put the result in loop of resource. So does this loop slow down…
Is it possible to detect when elements are hidden such as from inert or hidden? I have a sitemap page and my links use an IntersectionObserver and the mouseover event to detect when links are very visible to preload data.…
Scenario: I have a 2D array which represents background colours of cells in a spreadsheet object: [ ["#FFFF00", "#FFFF00", "#FFFF00", "#FFFF00", "#FFFF00", "#FFFF00"], ["", "", "", "", "", ""], ["#FFFF00", "#FFFF00", "#FFFF00", "#FFFF00", "#FFFF00", "#FFFF00"], ["#FFFF00", "#FFFF00", "#FFFF00", "#FFFF00", "#FFFF00",…