The single best way to improve determinism is to divide your acquisition/logging into two distinct producer/consumer loops as VTHokie says. Next best improvement would probably be using a binary format file structure rather than Write to Spreadsheet, which converts all data to ASCII representation prior to writing to file. Writing to ASCII files rather than binary files degrades performance in four ways:
- CPU must be used to do the number to text conversion
- ASCII represented numbers lose precision and don't exactly convert back to original data
- The filesize is larger
- When you go to read the file, it's slower for the above three reasons
On the other hand, an ASCII file is more portable - e.g., you can easily import into a third-party spreadsheet analysis program. But who in their right mind would export data OUTSIDE of LabVIEW when it offers best-in-industry analysis tools?
