speed up joins. Foreign keys should be indexes themselves, so
> they
> can also speed up joins. If the FK is not an index, it won't help. So,
> index your FKs
>
> On Wed, Oct 8, 2008 at 10:43 AM, Ben A.H. <[EMAIL PROTECTED]> wrote:
>
>> Does using foreign
Does using foreign keys simply enforce referential integrity OR can it also
speed up JOIN queries?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hello,
I'm having conceptualizing the correct relationship for what seems a very
simple scenario:
Scenario:
I have a standard "USERS" table...
USERS have a list of "FRIENDS", these can be other members or also non
members... Similar to facebook...
My main issue is conceptualizing the relations
I figured that was what you meant... I guess my table didn't work (see above
message...don't ya' love plaintext :-O)...
Has anyone ever tried to benchmark the difference between utilizing ENUMs
vs. traditional relational databasing? I would think ENUM is ideal for items
I specified at the begin
Hello all,
Thank-you for all of your help, I was really surprised by the speed &
quality of responses. Below is a table I've created based on some reading I
did following everyone's suggestions (I hope the table shows correctly)...
I'm leaning towards the pure Relational as I like having all da
backend?
I guess what I'm asking is: would this affect web-users in any way?
>
> Thanks
>
> On Mon, 2008-09-22 at 17:12 -0400, Ben A.H. wrote:
>> Hello,
>>
>> We are setting up a relatively common web application which collects
>> "user
>>
Hello,
We are setting up a relatively common web application which collects "user
information"... Right off the bat our system will have over 200,000 USER
RECORDS so having an efficient database & lookup scheme is critical.
I am a programmer/developer with some education in databasing but my for
