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
I have a tendency to design a user table in mysql as two tables users: id user_name password_hash user_info: user_id <- users.id first_name last_name email AIM ... There's a 1:1 relationship between users and user_info fields. I do this to try to speed up logons etc because depending on how much stuff I'm storing in user_info that table can get huge. The downside being it's a bit more work to implement the two tables. So My question is this worth it? Do I see a real speed bonus with this design or am I over complicating things? [img]http://www.bitdamaged.com/graphics/bitsig.gif[/img] .:[ Never resist a perfect moment ]:.
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