levylabpitt / LV-Data

Collection of LabVIEW VIs to read and write lab data.
BSD 3-Clause "New" or "Revised" License
3 stars 1 forks source link

Write Many Lines to PGSQL #101

Closed ciozi137 closed 1 year ago

ciozi137 commented 1 year ago

If one tries to write many (>10,000?) lines to in 1 INSERT command, something chokes and either crashes labview or the database. To get around this we can chop up the lines into segments of, for example, 1,000, and repeat 10x. I propose adding this feature directly to the API to save the user from having to do this:

[

Screen Shot 2023-08-05 at 9 37 29 AM

](url)

(In addition we can look into why the large INSERT is not working)