I am looking to load tag data for 75 tags over a period 6 years onto CSV or TXT or Excel. Whats the best & fastest way to do this - PISDK, POWERSHELL, PIOLEDB, PICONFIG or anything else?
Currently I use the old style piconfig, to load the data in batches of 2 months on to a CSV file as the file size becomes huge when i go over 2 months. 50 MB CSV file for 2 months data for a single tag. To give you a idea of how much data am trying to retrieve - Data count is ~1000000 events per tag over the duration of 2 months.
I would say the best way depends on you - in this case there is no "best" way based on the tools. Personally I would use a small C# programm and the PI SDK as this fits best to my skills and gives me great control on the size of the text files as well as the load on the server.