Gerard Daubar writes:
> I had one large table with information on the article and the article
> itself in the table. Now I split the table into the Info and the actual
> Article...
>
> This is nice because the actual articles are LONGTEXT type and could
> slow queries down I would imagine....and this would be unnecesary
> because at times I only need the Info part. For the queries that do need
> the article Info and actual Article...will the speed of having the 2
> queries (1 in each table) be any slower then if I had them still as one
> table?
>
> Thanks,
>
> Gerard
>
Hi!
Determination of entities in database design is not dependent on the
speed of the queries. Speed is regulated by indices.
Strength of SQL is in, among other things, possiblitity to make a
single query out of 1,2,3,4 ... N tables.
So, there is no reason why you should have two queries, each for
another table.
Sinisa
+---------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == [EMAIL PROTECTED] |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED] |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Belgrade |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|_____ Serbia |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+---------------------------------------------------------------------+
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
