Mike, You are correct. You can have a stable high performance dynamic web app with just Dynamo, and you do set it up in 2 tier fashion. This is all well and good if you do not have a lot of business logic involved, light transactions, and don't plan on reusing much or scaling. The versatility of the DB will help you out on this regard. This situation assumes persistent connections to the DB, which even though Dynamo supports connection pooling, can be a resource hog. Because these connections are open for so much longer than a typical jaguar request, you need more of them. A stateless component in Jaguar will connect to the db (using a pooled connection) when a method is called, and will disconnect when the method is completed, returning the connection to the pool. Since this connection is only used for 1 method and then returned, you can satisfy many more requests with fewer connections. Also, in the situation you described, your business logic would need to be coded in Dynascript (yuk) or Javascript. I can go deeper on this if you want. HTH, Kevin Ridley ----- Original Message ----- From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, December 21, 1999 8:07 AM Subject: PFCSIG Dynamo, Jaguar, and Adaptive Server(s) > First let me thank everyone who has responded to my original question of > whether you need Jaguar and Dynamo and PFC. Lot's of good opinions out > there. Along the same light, here is a new one. > > Adaptive server products (AnyWhere and Enterprise) seem to have included much > of the processing (balancing, multi-threading, etc.) that Jaguar seems to > have. Does this mean that by using Adaptive server products and PowerDynamo > that I can have a stable, high-performance dynamic HTML web/application > server environment? It appears so from the documentation. It also appears > that you should design your application in this environment like a two-tier, > which, if true, makes a lot of sense for efficiency, control, and reduced > cost of development. > > Where's Boris when we need him? - LOL. > > The reason that I am asking these questions is that I have been handed a > fairly large project that includes the following: > > Hand-helds using SQL Anywhere replicating to local server > Laptops to local server using internet > clients to local server (direct connect) > customer inquiries to local server using internet > local server replicating to corporate server using internet > laptops to corporate server using replication and internet > clients to corporate sever using internet > and catalogue capability from corporate server for customers using internet. > Yep, just about covers it all!!! > > So, any way of staying within a two-tier approach for development and > deployment is desirable from a development, deployment, and on-going cost > perspective. > > Anybody available to work on this project. All new code!!! > > Thanks in advance, > Mike > > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS > > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig > > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED] __________________________________________________ Do You Yahoo!? Thousands of Stores. Millions of Products. All in one place. Yahoo! Shopping: http://shopping.yahoo.com > [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS > A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig > SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]
