I've written apps that hosted images, but I NEVER put them in General or Memo fields. I simply stored the photos as jpegs and the path and filename to the file in the database.
John Harvey www.cyber-posse.com www.johnharveysheriff.com http://memphiscrime.blogspot.com www.votinginmemphis.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Crozier Sent: Wednesday, July 19, 2006 9:34 AM To: 'ProFox Email List' Subject: RE: Blobs AJ, I agree with Ed. If you are looking at blob images then VFP is not the most efficient tool to use. I gave up holding pictures/documents in our VFP files as the memo bloat was ENORMOUS and just crippled the system after running live a few months. I moved it over to MySQL and all those performance problems disappeared. 2 Gb may seem a lot but you will find you are constantly packing the mamo file to preserve any vestage of performance. Dave Crozier The secret to staying young is to live honestly, eat slowly, and to lie about your age -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of aj Sent: 19 July 2006 14:55 To: ProFox Email List Subject: Blobs In Fox9 is an fpt file generated per record when its used or per table? Im asking this because I read that its maximum size limit is 2 gigs and I'm going to need more than this in the future. Any help would be greatly appreciated. [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
