On Sunday 29 October 2023 at 16:03:28, Ivan Krylov via discuss wrote:
Our scientific application needs to store and query fundamental parameters for a number of molecules. There are 2 to 28 million rows per molecule, but the number of molecules is expected to stay small (currently 4).
With SET PROFILING=ON and the query cache disabled, the single operation with a duration of >1 second in the 23-row profile is "Sending data":
The first question I would ask about this is "what spec hardware are you running it on?" 1. How much RAM? 2. HDD or SSD? 3. CPU speed / cores? Also, you said "2 to 28 million rows per molecule, and 4 molecules", but what's the actual quantity of data (Gbytes used on disk)? Antony. -- "When you talk about Linux versus Windows, you're talking about which operating system is the best value for money and fit for purpose. That's a very basic decision customers can make if they have the information available to them. Quite frankly if we lose to Linux because our customers say it's better value for money, tough luck for us." - Steve Vamos, MD of Microsoft Australia Please reply to the list; please *don't* CC me.