What is max file size when writing to a database?

[unclebump]

I have an application that writes six columns of data to 24 tables in a single file. One column contains an array of 1100 points(DBL type), the rest are just single values. The file reached max size(1 GB) when each table contained over 3000 records. Should I split each table into an individual database file??

[Dennis_Knutson]

What type of database are you using? Access 2000 has a max size of 2Gb. Other, more robust databases like Oracle and SQL Server have no real limitations but a max size can be set by the database admin. Where is the database being stored and if on a server, what type and have any size restrictions been placed there by your IS department?

Splitting into individual databases might work but it all depends on how you need to link them to do queries and reports. Also, if you a running into a limitation of the allocated space on a server, then splitting the same amount of data across several files won't help.

[unclebump]

I am using the database toolset to write the data to the labview.mdb file. This is on a computer with win2000 and does not have microsoft office on it. The hard drive is formatted as FAT32, so we can do ghost backups with a dos boot disk. The data is stored on the same computer that is running the labview application. This is used on a cylinder block transfer machine, so I have managed to keep the IS dept. out of the loop. I just found the option to compact the database and it cut the file size in half.

[Dennis_Knutson]

I don't have the database connectivity toolkit so I can't open your VI. I would suspect that the file too large message would be coming back from your Access db and not from LabVIEW. The fact that compacting the db reduced the size in half says to me that the db schema is not normalized. I am not really a database expert and have relied on my IS department to get the maximum out of the databases I use. A quick call to them might help you optimize things.

[Zvezdana S.]

LabVIEW cannot handle files lerger than 2GB. This is becuase LabVIEW represents a file size in bytes with a 32 bit integer. So, the maximum file size you can get is ~2GB. Win95/98 has this same constraint. However, I believe WinNT represents file sizes with an I64 (probably 2 I32's together), allowing you to have much larger file sizes (~1TB). Unfortunately, LabVIEW still has the I32 representation for the file size, which still limits you to a 2GB file size even though WinNT can handle larger sizes.


How Can I Get LabVIEW to Read My Data File That is Greater Than 2 GB in Size?

If you operate on a system which can handle larger files and need to read a file
larger than 2GB, you can split up your data file using several free utilities that are available on the web. You can then use LabVIEW to read those smaller files. A good site to go to is: http://www.webattack.com/Freeware/downloader/fwfilesplit.shtml

Zvezdana S.