OZONE Asylum
Forums
Server-Side Scripting - Oh my!
MySQL design question
This page's ID:
28581
Search
QuickChanges
Forums
FAQ
Archives
Register
Edit Post
Who can edit a post?
The poster and administrators may edit a post. The poster can only edit it for a short while after the initial post.
Your User Name:
Your Password:
Login Options:
Remember Me On This Computer
Your Text:
Insert Slimies »
Insert UBB Code »
Close
Last Tag
|
All Tags
UBB Help
Yep DL you are right. [b]However[/b], "[i]First, indexes speed up retrievals but slow down inserts and deletes, as well as updates of values in indexed columns. That is, indexes slow down most operations that involve writing. This occurs because writing a record requires writing not only the data row, it requires changes to any indexes as well. The more indexes a table has, the more changes need to be made, and the greater the average performance degradation.[/i]" http://www.informit.com/articles/article.asp?p=377652&rl=1 Therefore, bitdamaged it all depends on the use you make of your tables... If they're really large, and if you need to write often in them, I don't think it would be useful, in terms of speed, to merge them. ---- If wishes were fishes, we'd all cast nets. [url=http://www.ozoneasylum.com/5700] [img]http://moon.shadow.free.fr/images/sigs/index.php[/img] [/url] [small](Edited by [url=http://www.ozoneasylum.com/user/2913]Moon Shadow[/url] on 10-27-2006 04:41)[/small]
Loading...
Options:
Enable Slimies
Enable Linkwords
« Backwards
—
Onwards »
Maximum Security
OZONE
DHTML/Javascript
Server-Side Scripting - Oh my!
CSS - DOM - XHTML - XML - XSL - XSLT
Stupid Basic HTML
Visual Therapy
Photoshop
Photoshop Pong, Anyone?
***WARNING*** BIG SIG APPROACHING
Photography
3D Modelling & Rendering
Multimedia/Animation
Print Graphics
Holding Pens
Philosophy and other Silliness
Outpatient Counseling
Site reviews!
Mad Scientists' Laboratory
Getting to know the Grail