Files PDF into sql table.

I have 5 millions of file PDF (acrobat) to save into a sql table.
Wich type of field can i use into a table ?
Thank you, Checco.You can use an IMAGE column. Why do you want to do this though?
Wouldn't it be easier just to store the file name? I don't think a PDF
could be very useful in a database.
This issue is discussed here:
http://www.aspfaq.com/show.asp?id=2149
--
David Portas
SQL Server MVP
--|||There is a transform in DTS which will load the files into the database (
Search for Textcopy I think it is).
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Checco" <CheccoTogliLaForka@.Box.it> wrote in message
news:392pnnF5tn0h9U1@.individual.net...
>I have 5 millions of file PDF (acrobat) to save into a sql table.
> Wich type of field can i use into a table ?
> Thank you, Checco.
>|||"David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> ha scritto nel
messaggio news:1110195059.693757.152650@.g14g2000cwa.googlegroups.com...
> You can use an IMAGE column. Why do you want to do this though?
> Wouldn't it be easier just to store the file name? I don't think a PDF
> could be very useful in a database.
>
I can save the files PDF in a file server... and access it by an URL like:
\\FileServer\Location\FileName but
i think that the access to a sqlserver is more fast than an access to a file
system, so, the files that i need is very much...
or not ?
Checco.|||No. Keep your files in a filesystem instead, and save the path to them in a
table. Access to a filesystem is much faster. You might want to create
subfolders following some criteria, since keeping 5 million files in one
folder would be a little costly performance wise. You might want to create a
hash function for the subfolder name. That discussion is outside of the
scope of this group.
-Argenis
"Checco" <CheccoTogliLaForka@.Box.it> wrote in message
news:393299F5tg5j0U1@.individual.net...
> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> ha scritto nel
> messaggio news:1110195059.693757.152650@.g14g2000cwa.googlegroups.com...
> > You can use an IMAGE column. Why do you want to do this though?
> > Wouldn't it be easier just to store the file name? I don't think a PDF
> > could be very useful in a database.
> >
> I can save the files PDF in a file server... and access it by an URL
like:
> \\FileServer\Location\FileName but
> i think that the access to a sqlserver is more fast than an access to a
file
> system, so, the files that i need is very much...
> or not ?
> Checco.
>|||Thank you.
Checco.
"Argenis Fernandez" <argenis@.spam.sucks.gmail.com> ha scritto nel messaggio
news:eZMNvqyIFHA.1860@.TK2MSFTNGP15.phx.gbl...
> No. Keep your files in a filesystem instead, and save the path to them in
> a
> table. Access to a filesystem is much faster. You might want to create
> subfolders following some criteria, since keeping 5 million files in one
> folder would be a little costly performance wise. You might want to create
> a
> hash function for the subfolder name. That discussion is outside of the
> scope of this group.
> -Argenis
> "Checco" <CheccoTogliLaForka@.Box.it> wrote in message
> news:393299F5tg5j0U1@.individual.net...
>> "David Portas" <REMOVE_BEFORE_REPLYING_dportas@.acm.org> ha scritto nel
>> messaggio news:1110195059.693757.152650@.g14g2000cwa.googlegroups.com...
>> > You can use an IMAGE column. Why do you want to do this though?
>> > Wouldn't it be easier just to store the file name? I don't think a PDF
>> > could be very useful in a database.
>> >
>> I can save the files PDF in a file server... and access it by an URL
> like:
>> \\FileServer\Location\FileName but
>> i think that the access to a sqlserver is more fast than an access to a
> file
>> system, so, the files that i need is very much...
>> or not ?
>> Checco.
>>
>