Where to store video frames?
-
My application captures individual data frames from a measuring device and stores them in an Access database via ODBC. It also has an option to record video (actually web cam) along with the data. My original thought would be to record the video file as as seperate file, and when the capture has finished, copy the whole file into the database as a longbinary field. Another way would be to store each video frame along with the data frame that it corresponds to into one database record. Any suggestions as to which way is better (or other ideas) Neil
-
My application captures individual data frames from a measuring device and stores them in an Access database via ODBC. It also has an option to record video (actually web cam) along with the data. My original thought would be to record the video file as as seperate file, and when the capture has finished, copy the whole file into the database as a longbinary field. Another way would be to store each video frame along with the data frame that it corresponds to into one database record. Any suggestions as to which way is better (or other ideas) Neil
soundman32 wrote: to record the video file as as seperate file, and when the capture has finished, copy the whole file into the database as a longbinary field. What about recording the video as a separate file, and at the end, store the path to that video file in the database? -- LuisR
Luis Alonso Ramos Intelectix - Chihuahua, Mexico Not much here: My CP Blog!