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:
Multiple Ad databases? (1997)
founditems (2000)
japanese characters (1997)
Separate SSL Server (1997)
unbreakable space on windows (2008)
Interpret Around Contexts? (2000)
Locking up with WebCatalog... (1997)
Grant, please help me ... (1997)
apostrophe in search item (1997)
URL'ed value not written to DB URL'ed (2003)
Expert tech support -- a fast and simple solution (long) ... (2000)
Comments in db? (1997)
Re2: frames & carts (1997)
I have troubles to send message out (1998)
WebCat2b15MacPlugin - showing [math] (1997)
wild question (1998)
OT - royalty free images (2002)
creating writefile data from a nested search (1997)
Date Formats (1997)
[WebDNA] localhost as email server (2011)