Gossamer Forum
Home : Products : Links 2.0 : Discussions :

Max field length ?

Quote Reply
Max field length ?
What is considered the maximum length of a field for Links 2.0? Is 15,000 characters out of the question?

Here's why I'm asking ...

In the past, we've used the (old) detail.cgi mod that allows you to store details in external files (I think widgetz wrote this). We have a lot of short articles on the site. The text files average 13k - 16k each, with a no more than 15,000 characters.

The downside of keeping the articles in external text files is that words are not included in the standard search results.

Our current database with 500 entries is only +- 183k. The files I'm thinking of adding are another 300k.

What are the implications of loading these directly into the db? Can the flat file properly handle this? Currently searches are blazing fast -- would having all the copy within the db greatly effect overhead, etc.?

Thanks -

Quote Reply
Re: Max field length ? In reply to
Disk space, field size, file size, etc...already been discussed before quite a few times in this forum.

Good luck!

Regards,

Eliot Lee
Quote Reply
Re: Max field length ? In reply to
The only information I was able to gleen by reading numerous threads (via a search before posting), was the 1 mb, +- 2000 -> 5000 links general rule of thumb. Nothing specifically address having a single field of this size.

Quote Reply
Re: Max field length ? In reply to
Read the following Threads:

http://www.gossamer-threads.com/...ew=&sb=&vc=1

http://www.gossamer-threads.com/...ew=&sb=&vc=1

http://www.gossamer-threads.com/...200&Old=allposts

http://www.gossamer-threads.com/...=&vc=1#Post77881

http://www.gossamer-threads.com/...200&Old=allposts

Good luck!

Regards,

Eliot Lee