Re: Database Strategy - more...
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18167
interpreted = N
texte = I response to Peter's comments (thx Peter): >>2. Is creating a single WebCat solution a better idea than coordinating >>WebCat and FoxPro databases? > >Is it right that the decision for in-house FoxPro is fixed? In this case >the WebCat solution you mentioned does not eliminate the sync problem, youJust to recap, there are two possible scenarios:A: In-house agents use the FoxPro solution and I try to keep the in-house FoxPro database synched up with the on-line WebCat database. or B: We scrap the FoxPro database and use ONLY a WebCat database/server solution which would be accessed via browser for both in-house agents and outside web surfers. >>3. Can a WebCat-based solution handle the speed needs of approx. 40 >>full-time users (25 in-house, 15 or so on-line)? > >What means fulltime? Can you explain this in terms like number of queries >or hits per minute? >I do not fear so much for WebCat, it runs still beside a webserver, so the >speed is limited and if you optimize performance (even with duplicated data >etc.) than it should run. But the 25 in-house users might bring the machine >itself into troubles, if they are very active on a 10baseT or 100baseT >network they can easily lock the server up. Get a fast machine!We are estimating a total of about 25 queries a minute, inclusive of all users. The in-house net is 10baseT - our outside link would be a full T-1. I guess one of my questions would be, is it faster to have 25 users searching against a multi-user FoxPro database or can a WebCat/server solution be as fast? Any database pros care to chime in? (I've seen a single-user demo of their FoxPro system and was underwhelmed by the performance but its still in development so its probably too early to tell.) Thanks -marty
Associated Messages, from the most recent to the oldest:
I response to Peter's comments (thx Peter): >>2. Is creating a single WebCat solution a better idea than coordinating >>WebCat and FoxPro databases? > >Is it right that the decision for in-house FoxPro is fixed? In this case >the WebCat solution you mentioned does not eliminate the sync problem, youJust to recap, there are two possible scenarios:A: In-house agents use the FoxPro solution and I try to keep the in-house FoxPro database synched up with the on-line WebCat database. or B: We scrap the FoxPro database and use ONLY a WebCat database/server solution which would be accessed via browser for both in-house agents and outside web surfers. >>3. Can a WebCat-based solution handle the speed needs of approx. 40 >>full-time users (25 in-house, 15 or so on-line)? > >What means fulltime? Can you explain this in terms like number of queries >or hits per minute? >I do not fear so much for WebCat, it runs still beside a webserver, so the >speed is limited and if you optimize performance (even with duplicated data >etc.) than it should run. But the 25 in-house users might bring the machine >itself into troubles, if they are very active on a 10baseT or 100baseT >network they can easily lock the server up. Get a fast machine!We are estimating a total of about 25 queries a minute, inclusive of all users. The in-house net is 10baseT - our outside link would be a full T-1. I guess one of my questions would be, is it faster to have 25 users searching against a multi-user FoxPro database or can a WebCat/server solution be as fast? Any database pros care to chime in? (I've seen a single-user demo of their FoxPro system and was underwhelmed by the performance but its still in development so its probably too early to tell.) Thanks -marty
Marty Schmid
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:
shipcost (1997)
SASL Support in WebDNA (2004)
[addlineitems] (1997)
Show shoppingcart after remove last item (1997)
syntax question, not in online refernce (1997)
Hard Questions ? (1997)
WCS Newbie question (1997)
[CART] inside a [LOOP] (1997)
I forgot (1998)
Some ThankYou page problems (1997)
message forum question (2005)
Users.db (1998)
Banners (1997)
multiple record replace (2001)
WebCatalog for guestbook ? (1997)
keep W* in front applescript? (1998)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
wc 2 pro users - sites, quotes wanted (1997)
group searching problem (2002)
Single Link browsing (1997)