Re: Help need to figure this out today!!! Advanced Question.
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 59800
interpreted = N
texte = Thanks for the reply. But is it a big deal for it to loop through a 100 Neighborhoods with a nested search in the listings db to only produce a drop down list of 10? Will the unnecessary searches be a problem for webdna or is this second nature to this application and I shouldn't worry about it. I don't think and of these related database will grow to more more then 150 records so that will be the max. I've already coded the code and it works very fast with no real noticeable difference. But do you know if this will be strain once I get thousands of hits a day or is it that WebDna can handle this without a sweat. Hosting with SmithMicro so I have their robust servers. on 10/28/2004 9:35 AM, Donovan Brooke at dbrooke@euca.us wrote: > Reggie from BRANDED wrote: > >> PROBLEM: I have 2 related databases: 1 a listing of businesses (listings.db) >> and 2 a list of neighborhoods (hoods.db). They are related by HoodID being >> store in the listings database. Need to generate a drop down list for a form >> in Alphabetical (ascending order) of the neighborhoods from the Listings >> database but I cannot do this unless I search the hoods.db first then do an >> embedded search in the listings.db. > > I think you answered your question. ;-) > > If you want a listing like: > > 1 Infinite Loop > Apple Computer > Alpha Quadrant > Fitzgerald's Bar > Johns Impliment > Zebra Bar > Maze Road > Bessy's Diner > Calloway Lumber > Zebra Road > Fury Critter Pet supplies > Pontiac > > etc.. I think you will need two searches. Just make sure you have > enough RAM and you should be fine. > > Donovan Branded Interactive 835 N. Wood St #103 Chicago, IL 60622 773.220.2851 www.BrandYourCompany.com ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Thanks for the reply. But is it a big deal for it to loop through a 100 Neighborhoods with a nested search in the listings db to only produce a drop down list of 10? Will the unnecessary searches be a problem for webdna or is this second nature to this application and I shouldn't worry about it. I don't think and of these related database will grow to more more then 150 records so that will be the max. I've already coded the code and it works very fast with no real noticeable difference. But do you know if this will be strain once I get thousands of hits a day or is it that WebDna can handle this without a sweat. Hosting with SmithMicro so I have their robust servers. on 10/28/2004 9:35 AM, Donovan Brooke at dbrooke@euca.us wrote: > Reggie from BRANDED wrote: > >> PROBLEM: I have 2 related databases: 1 a listing of businesses (listings.db) >> and 2 a list of neighborhoods (hoods.db). They are related by HoodID being >> store in the listings database. Need to generate a drop down list for a form >> in Alphabetical (ascending order) of the neighborhoods from the Listings >> database but I cannot do this unless I search the hoods.db first then do an >> embedded search in the listings.db. > > I think you answered your question. ;-) > > If you want a listing like: > > 1 Infinite Loop > Apple Computer > Alpha Quadrant > Fitzgerald's Bar > Johns Impliment > Zebra Bar > Maze Road > Bessy's Diner > Calloway Lumber > Zebra Road > Fury Critter Pet supplies > Pontiac > > etc.. I think you will need two searches. Just make sure you have > enough RAM and you should be fine. > > Donovan Branded Interactive 835 N. Wood St #103 Chicago, IL 60622 773.220.2851 www.BrandYourCompany.com ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/
Reggie from BRANDED
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:
WebMerchant and PCAuthorize (1998)
RE: webcat license???? (1997)
WebCat2 - Getting to the browser's username/password data (1997)
setlineiems and UnitShip Cost (2000)
Problems with date math (1997)
Signal Raised Error (Part II) (1997)
vars (2000)
Re:no template caching (1997)
Summary search -- speed (1997)
[SubTotal] ??? (1998)
Review comparison by PC Magazine: Open for On-lineBusiness (1997)
problem serving foreign languages text (1997)
local IIS setup (2004)
[WebDNA] Encrypt Method SHA256 (2018)
Problem with [CART] number (1998)
list items (1998)
Commitdatabase tag (1998)
Need help with emailer- 2 issues (1997)
webcat- multiple selection in input field (1997)
TCP Connect/send and CGI (2003)