Second Life Forums Archive - large database of text, how to serve?

PleaseWakeMeUp Idler

Registered User

Join date: 10 Oct 2006

Posts: 48

01-11-2008 21:35

(Sorry if this gets double posted, I could have sworn I sent it out this morning but I don't see it anywhere!)

I'm working on a script where I have to serve up a random line from a large Notecard. I have several problems.

The first is that my database of lines is much larger than a Notecard will hold. One database has 3500 lines, the other is not finished but I expect about 50,000 lines.

Yeah, Notecard is not the right tool for this job.

ALso, I used the script I found at:

http://wiki.secondlife.com/wiki/LlGetNumberOfNotecardLines

and it stopped responding after about 200 lines.

Notecards are certainly not the right tool for the job.

So, the question I have is:

What IS the right tool for the job?

Thanks

Wake

_____________________

Please visit http://www.SecondSeeker.com for reviews of "non-sleaze" SL sites.

Hewee Zetkin

Registered User

Join date: 20 Jul 2006

Posts: 2,702

01-11-2008 22:26

Either an external web server that your retrieve data from with llHTTPRequest(), or a library of notecards (several of them in prim inventory). Since you can retrieve the number of lines in each notecard, you can calculate which notecard the Nth line is in.

Void Singer

Int vSelf = Sing(void);

Join date: 24 Sep 2005

Posts: 6,973

01-12-2008 03:16

assuming the dataserver choked over 200 lines (and you didn't get a random error or some sort of throttling) 200 lines per notecard means 250 notecards for that 50k line database... I'd say go with a web server

_____________________

|
| . "Cat-Like Typing Detected"
| . This post may contain errors in logic, spelling, and
| . grammar known to the SL populace to cause confusion
|
| - Please Use PHP tags when posting scripts/code, Thanks.
| - Can't See PHP or URL Tags Correctly? Check Out This Link...
| -

Alicia Sautereau

if (!social) hide;

Join date: 20 Feb 2007

Posts: 3,125

01-12-2008 08:12

with that many lines i`ll agree with void, external is the best solution and just retrieve the lines that you want/need at that time

_____________________

large database of text, how to serve?
PleaseWakeMeUp Idler Registered User Join date: 10 Oct 2006 Posts: 48	01-11-2008 21:35 (Sorry if this gets double posted, I could have sworn I sent it out this morning but I don't see it anywhere!) I'm working on a script where I have to serve up a random line from a large Notecard. I have several problems. The first is that my database of lines is much larger than a Notecard will hold. One database has 3500 lines, the other is not finished but I expect about 50,000 lines. Yeah, Notecard is not the right tool for this job. ALso, I used the script I found at: http://wiki.secondlife.com/wiki/LlGetNumberOfNotecardLines and it stopped responding after about 200 lines. Notecards are certainly not the right tool for the job. So, the question I have is: What IS the right tool for the job? Thanks Wake _____________________ Please visit http://www.SecondSeeker.com for reviews of "non-sleaze" SL sites.
Hewee Zetkin Registered User Join date: 20 Jul 2006 Posts: 2,702	01-11-2008 22:26 Either an external web server that your retrieve data from with llHTTPRequest(), or a library of notecards (several of them in prim inventory). Since you can retrieve the number of lines in each notecard, you can calculate which notecard the Nth line is in.
Void Singer Int vSelf = Sing(void); Join date: 24 Sep 2005 Posts: 6,973	01-12-2008 03:16 assuming the dataserver choked over 200 lines (and you didn't get a random error or some sort of throttling) 200 lines per notecard means 250 notecards for that 50k line database... I'd say go with a web server _____________________ \| \| . "Cat-Like Typing Detected" \| . This post may contain errors in logic, spelling, and \| . grammar known to the SL populace to cause confusion \| \| - Please Use PHP tags when posting scripts/code, Thanks. \| - Can't See PHP or URL Tags Correctly? Check Out This Link... \| -
Alicia Sautereau if (!social) hide; Join date: 20 Feb 2007 Posts: 3,125	01-12-2008 08:12 with that many lines i`ll agree with void, external is the best solution and just retrieve the lines that you want/need at that time _____________________

Welcome to the Second Life Forums Archive

large database of text, how to serve?