Received: from funredes.org (funredes.org [205.160.164.9]) by hub.org (8.9.3/8.9.3) with SMTP id JAA10923 for ; Thu, 12 Aug 1999 09:53:07 -0400 (EDT) (envelope-from mike@fieldco.com) Received: from mike (net0port190.tricom.net) by funredes.org (5.x/SMI-SVR4) id AA09851; Thu, 12 Aug 1999 09:55:40 -0400 Message-Id: <009801bee4ca$b509d600$0200a8c0@mike> From: "Mike Field" To: Subject: Table size limit? Date: Thu, 12 Aug 1999 09:58:06 -0400 Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0095_01BEE4A9.2DEF0E40" X-Priority: 3 X-Msmail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.72.3155.0 X-Mimeole: Produced By Microsoft MimeOLE V4.72.3155.0 This is a multi-part message in MIME format. ------=_NextPart_000_0095_01BEE4A9.2DEF0E40 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi- I'm inserting documents of around 80K each into a table - I split up the = content into chunks of 8K each (I use a web interface with PHP), and = insert the chunks into the following fields: docid, content1, content2, content3, content4, ... , content10 (content fields are of type 'text') Question: will I ever run out of space in my table? I'll have about = 450 documents to start, then it'll grow indefinitely. =20 My other option, from what I hear, is to just have a field for each = document with the URL of the file (either .txt or .html or whatever). = Do you recommend this option over putting the content directly into the = dbase table?=20 Please let me know. Thanks, Mike mike@fieldco.com ------=_NextPart_000_0095_01BEE4A9.2DEF0E40 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi-
 
I'm inserting documents of around 80K each into a = table - I=20 split up the content into chunks of 8K each (I use a web interface with = PHP),=20 and insert the chunks into the following fields:
 
docid, content1, content2, content3, content4, ... , = content10
 
(content fields are of type 'text')
 
Question:  will I ever run out = of space in=20 my table?  I'll have about 450 documents to start, then it'll grow=20 indefinitely. 
 
My other option, from what I hear, is to just have a = field for=20 each document with the URL of the file (either .txt or .html or = whatever). =20 Do you recommend this option over putting the content directly into the = dbase=20 table? 
 
Please let me know.
Thanks,
Mike
 
mike@fieldco.com
= ------=_NextPart_000_0095_01BEE4A9.2DEF0E40--