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 Consultant 808-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:

    
  1. Re: DB approach question (Joseph D'Andrea 2000)
  2. Re: DB approach question (Kenneth Grome 2000)
  3. DB approach question (Serban Constantinescu 2000)
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 Consultant 808-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)