RE: re[2]: [ACFUG Discuss] Image from DB

2007-01-18 Thread Josh Adams
ng it. As with most things, your needs and priorities will dictate your choice. Josh _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mischa Uppelschoten ext 10 Sent: Thursday, January 18, 2007 3:38 PM To: Web Site Subject: re[2]: [ACFUG Discuss] Image from DB I b

re[2]: [ACFUG Discuss] Image from DB

2007-01-18 Thread Mischa Uppelschoten ext 10
I beg to differ. Text may need to be searched and edited, images cannot (easily) be searched or edited when placed in a db. Also, almost all my images happen to be larger than 8k, the limit for what fits in a record for SQL server, so they are placed in a different area, slowing retrieval

re[2]: [ACFUG Discuss] Image from DB

2007-01-18 Thread Mischa Uppelschoten ext 10
I'm doing this because I'm forced by a legacy application to do so, but it is a terrible strain on my CF and my db server. Most databases simply are not designed to efficiently handle these long records. Apart from that, editing an image becomes a nightmare. Security can be handled even i