Re: Fw: [SQL] and [index] mystery solved
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 38126
interpreted = N
texte = Bob McPeak wrote: > > For a variety of reasons (CORRUPTION!!) we're migrating many of our dbs to > SQL. Our trusty sys admin, Nick, has figured out a way to do a summary > report in the sql context founditems. > > Any general feedback on migrating to sql would be greatly appreciated. > Get yourself a book on SQL (for whatever flavor you are using). It is trivial to do summaries in SQL: select min(field) as min_field, other_field FROM table WHERE criteria GROUP BY other_fieldetc. It is also bad form to use select * ever, since that requires the database to do an additional lookup to the schema tables to figure out what fields are contained in that table. Always request only the fields you are going to immediately use, to limit the amount of network traffic dedicated to wasted data.When you move to a pure relational database, make sure that you do all of your joins in SQL, rather than building them up in WebCat. You can even create VIEW's in the backend database that encapsulate your most common joins. Depending on the server, a VIEW will be somewhat or a lot faster (since the query is already compiled and optimized).Learn how to use indexes effiently for your database. Oracle, for example, will not use an index unless you have all of the index fields in the WHERE clause (you can also use query hints). There are a lot of things that WebCatalog does for you that you will need to do yourself with you use an SQL database backend.HTHJohn -- 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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Bob McPeak wrote: > > For a variety of reasons (CORRUPTION!!) we're migrating many of our dbs to > SQL. Our trusty sys admin, Nick, has figured out a way to do a summary > report in the sql context founditems. > > Any general feedback on migrating to sql would be greatly appreciated. > Get yourself a book on SQL (for whatever flavor you are using). It is trivial to do summaries in SQL: select min(field) as min_field, other_field FROM table WHERE criteria GROUP BY other_fieldetc. It is also bad form to use select * ever, since that requires the database to do an additional lookup to the schema tables to figure out what fields are contained in that table. Always request only the fields you are going to immediately use, to limit the amount of network traffic dedicated to wasted data.When you move to a pure relational database, make sure that you do all of your joins in SQL, rather than building them up in WebCat. You can even create VIEW's in the backend database that encapsulate your most common joins. Depending on the server, a VIEW will be somewhat or a lot faster (since the query is already compiled and optimized).Learn how to use indexes effiently for your database. Oracle, for example, will not use an index unless you have all of the index fields in the WHERE clause (you can also use query hints). There are a lot of things that WebCatalog does for you that you will need to do yourself with you use an SQL database backend.HTHJohn -- 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://search.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:
webcatalog [date] bug (1999)
[WebDNA] Old Problem, the exclamation point (2014)
[WebDNA] Downloadable docs (2011)
searching illegal HTML (2002)
WebMerchant & CC Response (2002)
Content search & results (2008)
bannerads example idiot (1997)
[WebDNA] Error 500 with SUMM=T (2017)
Webcatalog/NT dbserver crashing. (2000)
Date search - yes or no (1997)
Formating found categories (1997)
WebCat 4.0x database losing data? (2003)
Nested tags count question (1997)
Not really WebCat (1997)
Shell on MacOSX (2004)
[shownext max=?] armed (1997)
OT: webstar/webcat monitoring aides? (1999)
WebDNA Prefs & Permissions (2005)
FW: I'll Know If You Don't Read This (2006)
webcat NT with [dos] command (1997)