What is the best programming language to use for operations on array elements?

Question

Arrays

Hello! There is a certain application written on VBA Excel.
Its essence is as follows - an array of about 50 thousand rows by 10 columns is created. The data types are numbers and date/time.
By some logic, the functions iterate over this array line by line and form a set of output data (in a Do while loop). Such searches need to be done from 600 to 900 thousand.
We encountered a speed problem, it takes several hours to process the array.
Tell me, please, in what language is it more rational to implement this application in order to speed up the process as much as possible?
Thanks everyone for the replies :)

Answer 1

Here, rather, the problem is in the optimal storage of data in memory and the speed of access to them. It begs the database engine.
Maybe you should try MSSQL?
Programming can also be done there. The result is saved in a separate table. Display in the same Excel.
If the speed of MSSQL is also low, then you will have to write your own engine optimized for the used data model and operations on them - using C ++ and parallel computing.

Answer 2

python numpy docs.scipy.org/doc/numpy-1.10.1/reference/generate...

Answer 3

To speed up the process as much as possible - in assembler.
The problem is that you may have to implement the calculation of the formula you mentioned in Assembler for more than one day.