Overall throughput is a pretty complicated subject. In general, the efficiency of factorysql depends a lot on the layout of the data (number of groups, what type of groups), in addition to the raw number of tags and the speed that you’re trying to log.
The native connector for SQL server is very efficient- usually taking just a few milliseconds for logging queries. Going to a remote server versus a local one doesn’t matter much, but of course that relies on exactly how remote it is- a different machine on the same network takes almost no extra time, but a server across the internet or a wan might be a different story. This later case is especially important when you consider that it is more likely that the connection might go down. FactorySQL will cache data, but the processes of detecting a down connection and then monitoring it to come back up is obviously more work than having it never go down.
Finally, depending on what you’re trying to accomplish (and how your data is laid out), using block groups can help improve throughput. Essentially, block groups allow you to define data together, in situations where you otherwise would have used a separate standard group for each row. Doing this allows multiple queries to be executed together as a transaction, which is way more efficient than doing them separately.
What kind of numbers are you talking about? I could throw out hypothetical situations, but since there’s so many ways to accomplish things it may help to get a rough idea of what you’re trying to accomplish.
Regards,