I need to make a query 2.5 million times. This query generates some rows, which I call average (Column) and then use this AVG to filter the table below all values by the average. Then I will have to do this filter results in a table
The only way to do this with such efficiency, for each query-postmaster dragon thread, a temporary table I think I just hope that this temporary table s will not remain in the hard drive (absolutely) and will be in memory (RAM), as long as it works from memory Are not out.
I would like to know that disk writes in a floating table (which will interfere with INSERTS, i.e. slows down the entire process)
Comments
Post a Comment