Computer Forums

Member Login

Remember Me? Sign Up! | Forgot Password
 
Slogan
 
Closed Thread
Old 07-25-2007, 12:25 PM   #1 (permalink)
 
Newb Techie

Join Date: Jul 2007

Posts: 3

Nikolas741 is on a distinguished road

Default MySQL Question

Need some input.

I have a relatively small database with a lot of columns. Trying to decide between Foreign Keys or simply using Join with Where clauses and just store the information in separate unassociated tables other than a key term.

What are some good pointers?
Nikolas741 is offline  
Old 07-25-2007, 04:27 PM   #2 (permalink)
 
Monster Techie

Join Date: May 2004

Location: Tucson, AZ, USA

Posts: 1,183

Vormund

Send a message via AIM to Vormund Send a message via MSN to Vormund Send a message via Yahoo to Vormund
Default Re: MySQL Question

It really depends on what the tables look like and what you're going for. :wooha:

If you know what you're doing - just deciding between the two - and have time, code both up, run some timing tests on them and make your decision based on that.
__________________
Vormund is offline  
 
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
RAID question? Ice8168 Building, Buying, or Upgrading High Performance PC Systems 15 07-20-2007 05:19 PM
Question about Video Cards and Compiz Fusion aetherh4cker Linux, BSD, other *nixes & Open Source Software 4 07-19-2007 04:16 PM
Question using RadioButton in VB.Net punkin Programming Discussions 4 07-08-2007 11:20 PM
Mobo Question Indobos Building, Buying, or Upgrading High Performance PC Systems 9 06-28-2007 11:45 PM
Ram OC question zetahammy Overclocking, Case Mod, Tweaking PC Performance 0 06-16-2007 01:18 AM