-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 12/02/07 07:35, rokj wrote: > Hi. > > For an example let me say that I have a big (over 1 million) user > "base". Then every user does a lot of inserting/updating of data. > Would it be better to create different tables for insert/updating for > every user or would it be better just to have one big table with all > data (tables would have of course the same columns, ...). How do you > cope with this kind of things? > > 1.example (1 enormous table) > tablename (id, user_id, datetime, some_data) > > 2. example (a big number of tables) > tablename_user_id( id, datetime, some_data) This should help you to decide how to design your tables. 3NF is as far as you really need to go. http://en.wikipedia.org/wiki/Data_normalization http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=88 - -- Ron Johnson, Jr. Jefferson LA USA %SYSTEM-F-FISH, my hovercraft is full of eels -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFHUvmzS9HxQb37XmcRAnNhAJ4/bMbLyDXioe7duTO4Dm0vBD8TCgCg3H84 /+gRlkgyuIlRYYGOGH8LWPM= =LfO7 -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
