[thelist] database structure for speedier queries

Joshua Olson joshua at waetech.com
Sun Dec 2 09:31:04 CST 2007


> From: r937
> Sent: Sunday, December 02, 2007 8:48 AM
> 
> > And which kind are you?
> 
> i would not use a boolean to indicate whether the project was complete
> 
> instead, i would use a column called completed_date

Complete nonsense... Clearly I'm right, because I would use a column called
date_completed.  :-)

<tip type="Clean URLs" author="Joshua Olson">
A great way to clean up URLs on a website is to use a URL ReWriting engine.
For example, it will allow you to change a url thusly:

http://www.mydomain.com/tools/articles.php?id=1465&title=The%20Title

Becomes:

http://www.mydomain.com/the-title/1465/

With a rewriting engine, this option comes at effectively no additional CPU
cost to the server while increasing the SE optimization of a page.
</tip>

<><><><><><><><><><>
Joshua L. Olson
WAE Technologies, Inc.
http://www.waetech.com/
Phone: 706.210.0168
Fax: 413.812.4864
Private Enterprise Number: 28752

Monitor bandwidth usage on IIS6 in real-time:
http://www.waetech.com/services/iisbm/ 



More information about the thelist mailing list