|
|
Posted by Norman Peelman on 01/27/07 19:51
Szymon Bobek wrote:
> Thank you all for help. But now I'm still wondering if this structure is
> really good. I mean - I read that it is better when there is more smaller
> tables that when you use one big table (MySQL searches faster)- that's why I
> decided to organize my database like that.
MySQL searches fastest when indexing and keys are involved. Anything
outside that will start hitting peformance issues. The bigger the
database the bigger the issue. The second you have to look at every row
in a table your performance is out the window (even when referencing
multiple tables)
> But is it true? When you can really feel that some data structures work
> faster than the others? Is it like matter of tables with milions of records
> only? Or if structure of database is crucial thing even for small databases?
> I'm asking, because I think that it would be easier form me to have just one
> big table then. Searching will be easier, adding easier, etc.
>
> Szymon
>
>
I'm assuming that searching/adding/updating/deleting will be easier
on one big table for you.
Norm
Navigation:
[Reply to this message]
|