Click here to Skip to main content
15,567,448 members
Home / Discussions / Database
   

Database

 
GeneralRe: MSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
Prasad A19-Feb-14 23:08
Prasad A19-Feb-14 23:08 
GeneralRe: MSSQL : Selecting a value from a row that has a column with minimun creation time for given parameters Pin
GuyThiebaut19-Feb-14 23:24
professionalGuyThiebaut19-Feb-14 23:24 
QuestionUpdate Database for C# application Pin
PDTUM19-Feb-14 7:06
PDTUM19-Feb-14 7:06 
AnswerRe: Update Database for C# application Pin
David Mujica19-Feb-14 9:39
David Mujica19-Feb-14 9:39 
AnswerRe: Update Database for C# application Pin
PDTUM20-Feb-14 6:54
PDTUM20-Feb-14 6:54 
QuestionRe: Update Database for C# application Pin
Nicholas Swandel21-Feb-14 4:55
Nicholas Swandel21-Feb-14 4:55 
AnswerRe: Update Database for C# application Pin
PDTUM21-Feb-14 6:50
PDTUM21-Feb-14 6:50 
GeneralRe: Update Database for C# application Pin
Nicholas Swandel21-Feb-14 7:20
Nicholas Swandel21-Feb-14 7:20 
5 million is not very big. Typically tables are indexed to make retrieval quick. Further there are other DB features such as partitioning that would allow the table to appear as one large table but the DB would actually store the table and its indexes in seperate partitions based on some attrubute, likely, in your case, a user id or more likely a set of user ids. Retreival would then only look at the index and table partitions for the individual user or set of users. Keep an open mind, I think your strong view that separate databases increase performance is miss placed. We have done a exercise of consolidating 50+ databases each with 30,000+ tables and 10 of millions of rows in some tables. Same harwdare and the performance gain was about 3 times, administration effort cut 3 fold. The memory and CPU requirements just to start a single DB is considerable, consolidating allows these resource to be better utilized and boosts performance. There is also the idea that each user could be contained in a schema within a single DB, this is a half measure though as will you would gain performance, administration would still be high. I would encourage you to try a proof of concept with a single table on 10-30 DBs shut down those DBS and compare it to the combined verion of the table on one DB with all the resources from the 10-30 DBS allocated to single DB. The single DB is typically dramatically faster.
Questionbegin tran in sql server 2008 Pin
vkEE19-Feb-14 6:22
vkEE19-Feb-14 6:22 
AnswerRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 7:02
professionalGuyThiebaut19-Feb-14 7:02 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 7:13
vkEE19-Feb-14 7:13 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 7:27
professionalGuyThiebaut19-Feb-14 7:27 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 7:43
vkEE19-Feb-14 7:43 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 8:32
professionalGuyThiebaut19-Feb-14 8:32 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 9:25
vkEE19-Feb-14 9:25 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 9:43
professionalGuyThiebaut19-Feb-14 9:43 
GeneralRe: begin tran in sql server 2008 Pin
Eddy Vluggen19-Feb-14 9:52
professionalEddy Vluggen19-Feb-14 9:52 
GeneralRe: begin tran in sql server 2008 Pin
Ananth A21-Feb-14 1:43
Ananth A21-Feb-14 1:43 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut21-Feb-14 1:56
professionalGuyThiebaut21-Feb-14 1:56 
GeneralRe: begin tran in sql server 2008 Pin
Eddy Vluggen19-Feb-14 9:25
professionalEddy Vluggen19-Feb-14 9:25 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 9:30
vkEE19-Feb-14 9:30 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 9:47
professionalGuyThiebaut19-Feb-14 9:47 
GeneralRe: begin tran in sql server 2008 Pin
vkEE19-Feb-14 9:59
vkEE19-Feb-14 9:59 
GeneralRe: begin tran in sql server 2008 Pin
GuyThiebaut19-Feb-14 11:26
professionalGuyThiebaut19-Feb-14 11:26 
GeneralRe: begin tran in sql server 2008 Pin
Eddy Vluggen19-Feb-14 9:59
professionalEddy Vluggen19-Feb-14 9:59 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.