Re: WebDNA + SQL Server
This WebDNA talk-list message is from 2003
It keeps the original formatting.
numero = 47367
interpreted = N
texte = 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.htmlhttp://www.kb.cert.org/vuls/id/635463http://www.cert.org/advisories/CA-2002-22.htmlJohn-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 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/
Associated Messages, from the most recent to the oldest:
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.htmlhttp://www.kb.cert.org/vuls/id/635463http://www.cert.org/advisories/CA-2002-22.htmlJohn-- John PeacockDirector of Information Research and TechnologyRowman & Littlefield Publishing Group4720 Boston WayLanham, MD 20706301-459-3366 x.5010fax 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/
John Peacock
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:
SMTP Mail Server (2003)
NT IIS number of files limit (2003)
Can you set [index]=end+1 for [break]? (1998)
shownext (1997)
WebTen? (1997)
[NT] ie 4.0 required (1997)
Re:Searching for ALL / empty form field (1997)
Duplicate Cart Numbers (1999)
WebCatalog-NT?'s (1996)
Carts in Admin folder? (1999)
WebCat b15 Mac plug-in (1997)
Re:quit command on NT (1997)
WebCat2b14MacPlugIn - [include] doesn't hide the search string (1997)
Date Sorting (1997)
Re:[ShowIf] and empty fields (1997)
Another bug to squash (WebCat2b13 Mac .acgi) (1997)
Help! Missing [showif] or [hideif] (2000)
Obscure Question of the day (1997)
Javascript Stored in a Database (2003)
[WebDNA] RSS Feed (2008)