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.html http://www.kb.cert.org/vuls/id/635463 http://www.cert.org/advisories/CA-2002-22.htmlJohn-- 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/ 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.html http://www.kb.cert.org/vuls/id/635463 http://www.cert.org/advisories/CA-2002-22.htmlJohn-- 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/ 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)