DB approach question
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 29005
interpreted = N
texte = Hi,I have a customer who wants a site something like monster.com, basically a site with Jobs, but not as monstrous as monster.com.I estimate that probably the number of resumes should be around 4000 at the most.I downloaded a sample resume from monster.com, and it takes about 2.5 kb.Question:What's the best approach in storing resumes:1) store each resume html formated, something like [resumeID].txt, and than display it as a resume.tpl?ID=[resumeID] with an [include file=[resumeID].txt]OR,2) store all the data in the resume.db databaseOR,3) any of your suggestionsI would tend to use option 1) to decrease the RAM loaded size of the database. How would the access to the disk based resume affect performance in 1) vs. 2)Would searching still be possible (text search) for the [resumeID].txt files?TIA,Serban-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
.To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Associated Messages, from the most recent to the oldest:
Hi,I have a customer who wants a site something like monster.com, basically a site with Jobs, but not as monstrous as monster.com.I estimate that probably the number of resumes should be around 4000 at the most.I downloaded a sample resume from monster.com, and it takes about 2.5 kb.Question:What's the best approach in storing resumes:1) store each resume html formated, something like [resumeID].txt, and than display it as a resume.tpl?ID=[resumeID] with an [include file=[resumeID].txt]OR,2) store all the data in the resume.db databaseOR,3) any of your suggestionsI would tend to use option 1) to decrease the RAM loaded size of the database. How would the access to the disk based resume affect performance in 1) vs. 2)Would searching still be possible (text search) for the [resumeID].txt files?TIA,Serban-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to
Serban Constantinescu
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
WebCat2 beta FTP site (1997)
WebCat2 beta 11 - new prefs ... (1997)
Numbers and Numbers and Me (1999)
shipcost (1997)
[WebDNA]
Single Link browsing (1997)
Sorry - the list went haywire... (1998)
New index for docs (1997)
Emailer port change (1997)
Upgrading old WebCat Database Files (1997)
.htm file tags not showing up (2000)
ReturnRaw and redirect one last question (1997)
Spawning Holdup? (2000)
Privacy Issue (LEGIT QUESTION) (2003)
Add a field to the error log? (1997)
japanese characters (1997)
Updating a database once per day - An example (1998)
Strange search... (2000)
searching by date range help needed (1997)
2.0.1 new commands and contexts (1997)