I agree. We use pointers to our images. It's very efficient.



AW: [pro_vb] RE: File Types



Hehe 
I've done a Picture Archive for SQL Server and Orakel :-)
I Just can say 1 - 2 Gigs are Ok but never go higher then 20 - 30 Gigs.
because of then it can happen that you loose data's or other mysteries :-/
Dave sad it correctly use the FileSystem and just store the reference on 
the database server.
File System is the best way when you have extremely large data's!


cheers Kilian


-----Ursprüngliche Nachricht-----
Von: Dave P [mailto:rwaters44@h...]
Gesendet: Mittwoch, 15. Januar 2003 17:34
An: professional vb
Betreff: [pro_vb] RE: File Types



I'm with Jeff on this! I've tried it and the performance on SQL server 
went 
right down the toilet. It was simpler and more efficient to store the file 
in a directory somewhere and just put the pointer in the database.


I tried to warn them, but they didn't believe me. Why didn't they believe 
me? Because they were already doing that with jpg & gif files. BIG, BIG, 
BIG, HUGE difference in file size and how they work...


As Jeff said...


Don't go there.




Dave(Hobbes)
rwaters44@h...


-"The Great Hyperbolic Omni-Cognate Neutron Wrangler" ... "could talk all 
four legs off an Arcturan Mega-Donkey - but only I could pursuade it to 
walk 
afterward."






----Original Message Follows----
From: "Jeff Mason" <je.mason@a...>
Reply-To: "professional vb" <pro_vb@p...>
To: "professional vb" <pro_vb@p...>
Subject: [pro_vb] RE: File Types
Date: Wed, 15 Jan 2003 11:24:48 -0500


It's possible, but not recommended - don't go there...


Basically you store it as a large binary object.  Manipulating the thing is
problematic, and it will inflate the size of your database considerably.


You are much better off parking the file in a directory somewhere and
storing only a pointer (i.e. filename) in the database.


-----Original Message-----
From: Niall Hannon (ext. 772) [mailto:Niall.Hannon@f...]
Sent: Wednesday, January 15, 2003 11:13 AM
To: professional vb
Subject: [pro_vb] File Types



Hi,


Is it possible to save .avi, .mpeg2 etc files in MS Acess or SQL Server? Is
it possible to store the complete file in a field of a table (using OLE
Object?) and then later play it from a vb app etc?



Thanks
Niall



**************************************************************************
The information contained in this e-mail is confidential,
may be privileged and is intended only for the use of the
recipient named above. If you are not the intended
recipient or a representative of the intended recipient,
you have received this e-mail in error and must not copy,
use or disclose the contents of this email to anybody
else. If you have received this e-mail in error, please
notify the sender immediately by return e-mail and
permanently delete the copy you received. This email has
been swept for computer viruses. However, you should
carry out your own virus checks.



Registered in Ireland, No. 205721. http://www.FINEOS.com
**************************************************************************



---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to 



---
Change your mail options at http://p2p.wrox.com/manager.asp or
to unsubscribe send a blank email to 



_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE*  
http://join.msn.com/?page=features/junkmail



---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to