Re: WebDNA + SQL Server

This WebDNA talk-list message is from

2003

It keeps the original formatting. numero = 47377
interpreted = N
texte = Thanks,The client has specifically said they want all their data stored in SQLServer - we don't see this as so much of a problem, just after somefeedback.We'll let you know how it goesAlain> We've done it for clients, and have had good performance. I would say the> WebDNA databases are faster, but I can't say how much faster. Like John> mentioned, I think the speed depends on what you're running the site on and> what calls you're making to SQL vs. WebDNA databases.> > I'd say a main drawback is the additional time you'll spend writing queries> for SQL that you probably already have in WebDNA (that's been our> experience, anyway). Another issue we've experienced is the licensing cost,> which often causes clients to change their minds on SQL.> > That being said, we have had clients that are big Microsoft supporters and> really wanted their data stored in SQL. It took a bit longer to code, but> the performance is still good, and the WebDNA/SQL combination definitely> outperforms the few ASP pages that are used for the clients' other sites> that run on the same server.> > Brian Looper> Project Manager> Smith Micro Software, Inc.> > > -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of John> Peacock> Sent: Monday, February 03, 2003 6:36 AM> To: WebDNA Talk> Subject: Re: WebDNA + SQL Server> > Alain Russell wrote:>> Can you let me know what performance is like ?> > WebCat is a RAM resident database, so it is likely to be 500-1000 times> faster> than the fastest disk-based database, but it is obviously limited to the> amount> of available RAM. I always suggest 'nearline' rather than 'online' if you> can> get away with it; i.e. WebCat always uses a 'recent' copy of the production> data, where 'recent' is determined by how often updates are made.> > There is nothing to stop you from having the searchable database be in> WebCat> exclusively and the R/W databases be in some external SQL database. I would> strongly recommend against having all of your databases in SQL, since you> would> be wasting your time using WebCat (see RAM resident database above ;~) and> likely your performance would be worse than ASP, for example.> >> Any other gotchas ?> > Just the usual:> > http://www.cert.org/incident_notes/IN-2002-04.html> http://www.kb.cert.org/vuls/id/635463> http://www.cert.org/advisories/CA-2002-22.html> > John> > --> John Peacock> Director of Information Research and Technology> Rowman & Littlefield Publishing Group> 4720 Boston Way> Lanham, MD 20706> 301-459-3366 x.5010> fax 301-429-5747> > > -------------------------------------------------------------> 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/> > -------------------------------------------------------------> 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/-------------------------------------------------------------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,The client has specifically said they want all their data stored in SQLServer - we don't see this as so much of a problem, just after somefeedback.We'll let you know how it goesAlain> We've done it for clients, and have had good performance. I would say the> WebDNA databases are faster, but I can't say how much faster. Like John> mentioned, I think the speed depends on what you're running the site on and> what calls you're making to SQL vs. WebDNA databases.> > I'd say a main drawback is the additional time you'll spend writing queries> for SQL that you probably already have in WebDNA (that's been our> experience, anyway). Another issue we've experienced is the licensing cost,> which often causes clients to change their minds on SQL.> > That being said, we have had clients that are big Microsoft supporters and> really wanted their data stored in SQL. It took a bit longer to code, but> the performance is still good, and the WebDNA/SQL combination definitely> outperforms the few ASP pages that are used for the clients' other sites> that run on the same server.> > Brian Looper> Project Manager> Smith Micro Software, Inc.> > > -----Original Message-----> From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of John> Peacock> Sent: Monday, February 03, 2003 6:36 AM> To: WebDNA Talk> Subject: Re: WebDNA + SQL Server> > Alain Russell wrote:>> Can you let me know what performance is like ?> > WebCat is a RAM resident database, so it is likely to be 500-1000 times> faster> than the fastest disk-based database, but it is obviously limited to the> amount> of available RAM. I always suggest 'nearline' rather than 'online' if you> can> get away with it; i.e. WebCat always uses a 'recent' copy of the production> data, where 'recent' is determined by how often updates are made.> > There is nothing to stop you from having the searchable database be in> WebCat> exclusively and the R/W databases be in some external SQL database. I would> strongly recommend against having all of your databases in SQL, since you> would> be wasting your time using WebCat (see RAM resident database above ;~) and> likely your performance would be worse than ASP, for example.> >> Any other gotchas ?> > Just the usual:> > http://www.cert.org/incident_notes/IN-2002-04.html> http://www.kb.cert.org/vuls/id/635463> http://www.cert.org/advisories/CA-2002-22.html> > John> > --> John Peacock> Director of Information Research and Technology> Rowman & Littlefield Publishing Group> 4720 Boston Way> Lanham, MD 20706> 301-459-3366 x.5010> fax 301-429-5747> > > -------------------------------------------------------------> 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/> > -------------------------------------------------------------> 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/-------------------------------------------------------------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/ Alain Russell

DOWNLOAD WEBDNA NOW!

Re: WebDNA + SQL Server

2003

Top Articles:

Related Readings: