Hi, Just about to attempt this process from .NET using UODOTNET, anyone have any advice off the bat, any concerns I should have?
Thanks, Pete ________________________________ From: [EMAIL PROTECTED] on behalf of Uffe Toft Sent: Mon 18/12/2006 8:37 AM To: [email protected] Subject: [U2] Storing images on U2 database. Hi Jeff, I'll recommend a Dynamic UniVerse file (TYPE 30) for storing binary data like images. Most likely all records will be stored as "large records" giving almost direct assess. It performs fine and there is no practical limits in the total size or the no. of records to be stored in a 64BIT file. Alternatively, you could for administrative reasons spread the images in more 32BIT files each holding maybe 2GB. The internal format of Dynamic files makes it also a protected way of storing READONLY images. Using TYPE 1 or 19 files will slow down the OS system, if you have hundreds of thousands or millions of images You will need a TYPE 1or 19 file as a temporary place for moving binary files to and from the Dynamic file. Any UniVerse reads and writes to the TYPE 1 or 19 file must by binary. E.g.: READ IMAGE.RECORD FROM F.DYNAMIC.FILE, IMAGE.ID ELSE END ASSIGN SYSTEM(1017) TO 1 ;* binary on WRITE IMAGE.RECORD TO F.TYPE19_FILE, IMAGE.ID ASSIGN SYSTEM(1017) TO 0 ;* binary off The method may be different in UniData. Regards, Uffe Toft Steria Denmark [demime 1.01d removed an attachment of type application/ms-tnef which had a name of winmail.dat] ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
