Gossamer Forum
Home : Products : Links 2.0 : Discussions :

Is 50 defined fields to many?

Quote Reply
Is 50 defined fields to many?
Hello,

I have a large number of fields that I want to define in links.def

Is 50 or 75 fields to much for the program to handle?

------------------
James L. Murray
VirtueTech, Inc.
www.virtuetech.com


Quote Reply
Re: Is 50 defined fields to many? In reply to
it only means you can't handle as many links..

when i did the geturl.cgi it worked until 200,000+ links cause there were only 4 fields

URL|Title|Description|Last Modified

and the max length of title was 50.. max of desciprtion was 150.. so it was able to store alot.. then when it got so high.. it pretty much died.. it could no longer finish reading the database.. so it never modified the database but it kept appending to it..

you might want to weed out some of the things that you don't really need..

or you can put all the same option fields into another database.. like option.db

and then build up hashes.. but it takes more memory..

jerry

[This message has been edited by widgetz (edited November 14, 1999).]
Quote Reply
Re: Is 50 defined fields to many? In reply to
I don't understand....what options?

Can you elaborate. Smile

------------------
James L. Murray
VirtueTech, Inc.
www.virtuetech.com


Quote Reply
Re: Is 50 defined fields to many? In reply to
like all the "yes" or "no" fields..

you can easily put it into a hash by doing something like:

Code:
open DB, "options.db";
@db = <DB>;
foreach (grep {!/^#/ and !/^\s*$/} @db) {
@options = split /\|/, $_;
for ($i = 1; $i < $#options; $i++) {
next if ($options[$i] = "No");
${$opt[$i]}{$option[0]} = 1;
}
}
close DB;

nevermind. don't do it.. that's practically the same thing as using multiple databases..

jerry
Quote Reply
Re: Is 50 defined fields to many? In reply to
  Smile

Thats what I thought. So I can use Links 2.0 for about 200,000 links with 50 fields?

Or better yet..how big can my database be before Links 2.0 can't process it any more and I need to upgrade?

Jerry, can you PLEASE help me out to set up multiple databases?

------------------
James L. Murray
VirtueTech, Inc.
www.virtuetech.com




[This message has been edited by Ground Zero (edited November 14, 1999).]
Quote Reply
Re: Is 50 defined fields to many? In reply to
i'm not interested in going through all THAT again Smile

i have to get it to be bugfree on links sql.. which shouldn't be as hard. just specify the db in the category database..

jerry