Re: [SQL] BLOBs vs BYTEA

2005-02-01 Thread Karl Denninger
On Tue, Feb 01, 2005 at 10:04:45AM +0200, Achilleus Mantzios wrote: > O Dennis Sacks Ýãñáøå óôéò Jan 31, 2005 : > > > Sam Adams wrote: > > > > >Anyway, I was wondering which would be a better way to store a large > > >amount of files each a few megabytes in size. There could be hundreds of > > >t

Re: [SQL] BLOBs vs BYTEA

2005-01-31 Thread Achilleus Mantzios
O Dennis Sacks έγραψε στις Jan 31, 2005 : > Sam Adams wrote: > > >Anyway, I was wondering which would be a better way to store a large > >amount of files each a few megabytes in size. There could be hundreds of > >thousands of files altogether. If stored as BYTEAs this would put them > >all in a

Re: [SQL] BLOBs vs BYTEA

2005-01-31 Thread Dennis Sacks
Sam Adams wrote: Anyway, I was wondering which would be a better way to store a large amount of files each a few megabytes in size. There could be hundreds of thousands of files altogether. If stored as BYTEAs this would put them all in a single table. Would this effect performance considerablely?

[SQL] BLOBs vs BYTEA

2005-01-31 Thread Sam Adams
Hi, Apologies if I've already sent a post asking this but I'm not sure if it actually went through last time as it doesn't seem to be in my sent items box. Anyway, I was wondering which would be a better way to store a large amount of files each a few megabytes in size. There could be hundreds of