Re: DB approach question
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 29007
interpreted = N
texte = If you don't have to searchthe resumes via webcat, store them in separate files and refer to them with a reference in one of your db fields, this will keep the db smaller.>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 database>>OR,>>3) any of your suggestions>>I 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 ================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================-------------------------------------------------------------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:
If you don't have to searchthe resumes via webcat, store them in separate files and refer to them with a reference in one of your db fields, this will keep the db smaller.>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 database>>OR,>>3) any of your suggestions>>I 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 ================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================-------------------------------------------------------------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
Kenneth Grome
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:
Dubble Sku's in a Database (1999)
Add to a filename in multifile upload (2002)
SSL and reg web* (1997)
Multiple fields on 1 input (1997)
Problem displaying search result (1997)
Verifying both name and password (was: THANKS) (1997)
Wrapping text (1998)
Math Problem - Format? (1997)
webcat- multiple selection in input field (1997)
Navigator 4.0 & tables (1997)
autosensing lanague selection (1997)
Hard Questions ? (1997)
Search crashing server (1998)
HTML encoding in URLs (1997)
Likelihood of a duplicate (2005)
Using Plug-In while running 1.6.1 (1997)
Major Security Hole (1998)
[subtotal] (2000)
RE: OK, here goes... (1997)
Card clearance, problems - solutions? (1997)