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.
_______________________________________________
discuss mailing list -- [email protected]
To unsubscribe send an email to [email protected]
