You are here: What is better to use? « MsSQL Server « IT news, forums, messages
What is better to use?

Posted by Igor on 04/16/07 13:06

I currently have two tables:
1: users
id_user
username

2: baned_users
id_user

i tought i could use something like this
1: users
id_user
username
is_baned

So would it be better to use two tables like in first example or one
table like in second example? Offcourse, not many users would be baned
(i hope). I currently have 59 joins with baned_users table in my
stored procedures, two of those are executed on every access to the
website (2xtop 20 users), what way should i use?

Sorry for my bad english.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация