Range of Reports- go relational or include file?

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 30951
interpreted = N
texte = I have a project I am working on and wonder which way will be the best to solve the solution the client needs. It for a newspaper that has a searchable archive of data. They have to sections that displays the data, one is a traditional search are that customer pay access to and an other is a 'daily' section that has public access. They want to Display only that days data in the public section, and I have that working fine. What I am interested in is how to build the admin section of what information is displayed.There are 30 odd databases and the data displayed is based on either a range of dates or a range of serial numbers. Should I build a separate database that the daily pages perform lookups into as part of it search criteria or should I build an include file that just lists name=value pairs for each database.It comes down to either doing a lookup in a search context or pulling in an include file declaring variable values ([DataBaseOneRange]=73482+73528) that gets used in the search context. I think the latter would be more efficient but I am not sure about caching issues, in other words if the client performs an update to the file, should we need to purge apache's cache for it to take?Any insight into this matter would be greatly appriciated. -- Eric Ridgley, Web/Graphic Designer...............Phone: 330.630.4487 Silver Creek, Ltd. ...............Fax: 330.630.5786 143 Northwest Avenue, Suite B101 ...............URL: www.silvercreek.net/ Tallmadge Ohio 44278 ...............URL: www.ridgley.org/------------------------------------------------------------- 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. Range of Reports- go relational or include file? (Eric Ridgley 2000)
I have a project I am working on and wonder which way will be the best to solve the solution the client needs. It for a newspaper that has a searchable archive of data. They have to sections that displays the data, one is a traditional search are that customer pay access to and an other is a 'daily' section that has public access. They want to Display only that days data in the public section, and I have that working fine. What I am interested in is how to build the admin section of what information is displayed.There are 30 odd databases and the data displayed is based on either a range of dates or a range of serial numbers. Should I build a separate database that the daily pages perform lookups into as part of it search criteria or should I build an include file that just lists name=value pairs for each database.It comes down to either doing a lookup in a search context or pulling in an include file declaring variable values ([DataBaseOneRange]=73482+73528) that gets used in the search context. I think the latter would be more efficient but I am not sure about caching issues, in other words if the client performs an update to the file, should we need to purge apache's cache for it to take?Any insight into this matter would be greatly appriciated. -- Eric Ridgley, Web/Graphic Designer...............Phone: 330.630.4487 Silver Creek, Ltd. ...............Fax: 330.630.5786 143 Northwest Avenue, Suite B101 ...............URL: www.silvercreek.net/ Tallmadge Ohio 44278 ...............URL: www.ridgley.org/------------------------------------------------------------- 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 Eric Ridgley

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:

Re:Remote stockroom ? (1998) WebTen? (1997) [ot] html question (2000) Database Security (1998) For those of you not on the WebCatalog Beta... (1997) [addlineitems] (1997) Converting characters to numbers ... (1997) anyone integrated inventory w/ storebuilder? (2003) WebCat2 - many [carts] on one template page? (1997) IIS Brain Dead (1998) Field name-subcategory (1997) I can help! (1996) Credit Card Processing (2000) Further tests with the infamous shipCost (1997) RE: [WebDNA] ONLY the FIRST continuous run of numeric chars? (2008) searchable list archive (1997) Multiple cart additions (1997) Problem: 3.0 doesn't update carts (1997) Not really WebCat - need HTML Grider (1997) Entry pages (was: WebCatalog MAJOR drawback) (1998)