|
|
|
|
||||
|
Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact us. |
 |
|
|||||||
| Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed. |
|
|
Thread Tools |
07-20-2006, 01:53 AM
|
#1 |
|
Beer Money Baron
Industry Role:
Join Date: Jan 2001
Location: brujah / gmail
Posts: 22,157
|
Why Can't Database Tables Index Themselves?
Here's a thought question for today: why can't database tables index themselves?
http://www.codinghorror.com/blog/archives/000638.html ... in a modern client-server database, the server should be aware of all the queries flowing through the system, and how much each of those queries cost. Who better to decide what needs to be indexed than the database itself?
__________________
|
|
|
|
07-20-2006, 02:13 AM
|
#2 |
|
...
Join Date: Jan 2006
Location: Maryland ICQ:87038677
Posts: 11,542
|
it is a mystery
__________________
... |
|
|
|
|
07-20-2006, 12:07 PM
|
#3 |
|
Confirmed User
Join Date: Dec 2004
Location: the center
Posts: 1,454
|
__________________
 icq 199437756 - contact me if you need a solid hosting solution |
|
|
|
|
07-20-2006, 12:13 PM
|
#4 |
|
Sofa King Band
Join Date: Jul 2002
Location: Outside the box
Posts: 29,903
|
Having a computer pick and choose anything is spotty at best.
I love it when a computer can make recommendations and show me things I might not have thought of otherwise, but if it just indexed itself, I might get semi ticked.... as it would likely not be exactly how I want it. |
|
|
|
|
07-20-2006, 12:53 PM
|
#5 |
|
<&(©¿©)&>
Industry Role:
Join Date: Jul 2002
Location: Chicago
Posts: 47,882
|
If everything was automatic what would database experts do then?
__________________
Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager  Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager |
|
|
|
|
07-20-2006, 07:09 PM
|
#6 |
|
Beer Money Baron
Industry Role:
Join Date: Jan 2001
Location: brujah / gmail
Posts: 22,157
|
At least the Query Cache exists now, and has been a dramatic help on my db driven sites. Would be interesting for a tool to automatically suggest indexes or optimizations to the db administrator. Maybe it could parse a slow queries log or analyze 'show variables' and make recommendations.
__________________
|
|
|
|
|
07-20-2006, 07:29 PM
|
#7 | |
|
Too lazy to set a custom title
Join Date: Oct 2002
Location: Far far away - as possible
Posts: 14,956
|
Quote:
 Any DB stuff I've done was auto indexed on whatever fields were defined to be indices. DB queries may be another matter, but can be ... eg on a from and to date - hit in to an indexed "from date" run the query to the "to date" and quit - ignoring all else. Tho.. can see what you mean - that's another program to give everything sense and avoid human thought 
__________________
XXX TLD's - Another mosquito to swat. |
|
|
|
|
