Click here to Skip to main content
15,947,476 members
Home / Discussions / Database
   

Database

 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Sandeep Tripathi25-Mar-15 2:16
Sandeep Tripathi25-Mar-15 2:16 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Eddy Vluggen25-Mar-15 3:11
professionalEddy Vluggen25-Mar-15 3:11 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Corporal Agarn25-Mar-15 4:00
professionalCorporal Agarn25-Mar-15 4:00 
AnswerRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Tim Carmichael25-Mar-15 2:33
Tim Carmichael25-Mar-15 2:33 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Sandeep Tripathi25-Mar-15 2:43
Sandeep Tripathi25-Mar-15 2:43 
GeneralRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Tim Carmichael25-Mar-15 2:52
Tim Carmichael25-Mar-15 2:52 
AnswerRe: Sql server 2008 R2 Express Edition working very slow why? Pin
David Mujica25-Mar-15 3:35
David Mujica25-Mar-15 3:35 
AnswerRe: Sql server 2008 R2 Express Edition working very slow why? Pin
jschell25-Mar-15 11:50
jschell25-Mar-15 11:50 
I will note that I have tested an application that was running 100 TPS (Transactions Per second) sustained on 32 bit machines where every transaction was hitting the database multiple times on a network with multiple client machines, a single app server and a single database server (again 32 bit with 2 CPUs.)

And I was never able to get the CPU on the database server machine to go above about 3%. The database was never even close to being a bottleneck.

I seriously doubt that 40 human users doing normal click through work would even be able to touch a 64 bit machine on even a adequately designed system.

Normal performance problems are as follows from most to least
1. Requirements (most impact)
2. Architecture/Design
3. Implementation
4. Technology (network, language, OS, etc.) (least impact)

Now as per the other threads very badly configuring a server could have an impact. But so can 1-3 in the above.

If it is the database server then reinstalling and accepting all of the defaults would return it to the base line and that would be more than adequate for very long time even with a substantial increase in human users. If of course 1-3 are done right.
AnswerRe: Sql server 2008 R2 Express Edition working very slow why? Pin
Mycroft Holmes25-Mar-15 15:35
professionalMycroft Holmes25-Mar-15 15:35 
Questionhow to create a chart from a database in android eclipse .. please help me :D Pin
Pungkas Soebarkah24-Mar-15 23:24
Pungkas Soebarkah24-Mar-15 23:24 
AnswerRe: how to create a chart from a database in android eclipse .. please help me :D Pin
Mycroft Holmes25-Mar-15 15:16
professionalMycroft Holmes25-Mar-15 15:16 
QuestionNDF File Pin
Member 1133602724-Mar-15 8:45
Member 1133602724-Mar-15 8:45 
QuestionRe: NDF File Pin
ZurdoDev24-Mar-15 8:51
professionalZurdoDev24-Mar-15 8:51 
AnswerRe: NDF File Pin
Richard Deeming24-Mar-15 9:15
mveRichard Deeming24-Mar-15 9:15 
AnswerRe: NDF File Pin
Richard Deeming24-Mar-15 9:18
mveRichard Deeming24-Mar-15 9:18 
QuestionHelp needed on string function Pin
Ambertje24-Mar-15 6:01
Ambertje24-Mar-15 6:01 
AnswerRe: Help needed on string function Pin
Kornfeld Eliyahu Peter24-Mar-15 7:42
professionalKornfeld Eliyahu Peter24-Mar-15 7:42 
GeneralRe: Help needed on string function Pin
Ambertje24-Mar-15 23:43
Ambertje24-Mar-15 23:43 
GeneralRe: Help needed on string function Pin
Johan Hakkesteegt8-Apr-15 2:36
Johan Hakkesteegt8-Apr-15 2:36 
QuestionVB.NET MYSQL DATATABLE Pin
Pauls Pauls21-Mar-15 4:33
Pauls Pauls21-Mar-15 4:33 
AnswerRe: VB.NET MYSQL DATATABLE Pin
Peter Leow21-Mar-15 4:56
professionalPeter Leow21-Mar-15 4:56 
AnswerRe: VB.NET MYSQL DATATABLE Pin
manchanx21-Mar-15 5:14
professionalmanchanx21-Mar-15 5:14 
GeneralRe: VB.NET MYSQL DATATABLE Pin
Pauls Pauls21-Mar-15 6:16
Pauls Pauls21-Mar-15 6:16 
QuestionOracle, inner join and substr function Pin
Ludwing RS20-Mar-15 9:29
Ludwing RS20-Mar-15 9:29 
AnswerRe: Oracle, inner join and substr function Pin
Eddy Vluggen20-Mar-15 10:21
professionalEddy Vluggen20-Mar-15 10:21 

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.