Re: [GENERAL] Saving a jpg into Postgresql table

2006-08-25 Thread Kaloyan Iliev
Gibson wrote: Hi guys, I have a projects using ASP.NET (VB.net) where i upload a jpeg file using a web form and then save the jpeg file into a table. I've decided to use Oid instead of Bytea as i heard that Oid is more memory efficient. So can anyone point me to a website or link where i

Re: [GENERAL] Saving a jpg into Postgresql table

2006-08-25 Thread Jeff Davis
On Fri, 2006-08-25 at 10:10 +0300, Kaloyan Iliev wrote: I have a projects using ASP.NET (VB.net) where i upload a jpeg file using a web form and then save the jpeg file into a table. I've decided to use Oid instead of Bytea as i heard that Oid is more memory efficient. So can anyone

Re: [GENERAL] Saving a jpg into Postgresql table

2006-08-25 Thread Karsten Hilbert
On Fri, Aug 25, 2006 at 10:17:34AM -0700, Jeff Davis wrote: It takes aproximately 25-30% more disk space but is much easier for me to operate with it. When I read the object from the database I decode it and I have the file in the original format. Why not go a step further and do

Re: [GENERAL] Saving a jpg into Postgresql table

2006-08-25 Thread Jeff Davis
On Fri, 2006-08-25 at 22:49 +0200, Karsten Hilbert wrote: On Fri, Aug 25, 2006 at 10:17:34AM -0700, Jeff Davis wrote: It takes aproximately 25-30% more disk space but is much easier for me to operate with it. When I read the object from the database I decode it and I have the file

[GENERAL] Saving a jpg into Postgresql table

2006-08-24 Thread Gibson
Hi guys, I have a projects using ASP.NET (VB.net) where i upload a jpeg file using a web form and then save the jpeg file into a table. I've decided to use Oid instead of Bytea as i heard that Oid is more memory efficient. So can anyone point me to a website or link where i can see the

Re: [GENERAL] Saving a jpg into Postgresql table

2006-08-24 Thread Michael Fuhr
On Thu, Aug 24, 2006 at 06:25:28PM +0800, Gibson wrote: I have a projects using ASP.NET (VB.net) where i upload a jpeg file using a web form and then save the jpeg file into a table. I've decided to use Oid instead of Bytea as i heard that Oid is more memory efficient. See the Large