joewazen 23 Newbie Poster

Hello,

can anyone help me find a document explaining a general way to design "Live" tables in SQL?

i have an application linked to a db that contains live tables in it (tables that have records always updated, inserted, deleted and many applications read/write in it)

my biggest worry is to keep those tables clean and light in order not to have deadlocks, long waits, slowness...