Click here to Skip to main content
14,366,974 members
   

Database

 
AnswerRe: MySQL database Pin
#realJSOP18-Sep-19 2:08
mve#realJSOP18-Sep-19 2:08 
GeneralRe: MySQL database Pin
Alboyz18-Sep-19 17:58
memberAlboyz18-Sep-19 17:58 
AnswerRe: MySQL database Pin
Mycroft Holmes18-Sep-19 13:44
memberMycroft Holmes18-Sep-19 13:44 
GeneralRe: MySQL database Pin
Alboyz18-Sep-19 17:58
memberAlboyz18-Sep-19 17:58 
QuestionDatabase suddenly slow Pin
Super Lloyd17-Sep-19 16:39
memberSuper Lloyd17-Sep-19 16:39 
AnswerRe: Database suddenly slow Pin
CHill6018-Sep-19 1:05
protectorCHill6018-Sep-19 1:05 
GeneralRe: Database suddenly slow Pin
Super Lloyd18-Sep-19 21:47
memberSuper Lloyd18-Sep-19 21:47 
AnswerRe: Database suddenly slow Pin
Richard Deeming18-Sep-19 2:01
mveRichard Deeming18-Sep-19 2:01 
Check the execution plan. Check that you have the correct indexes on the tables. Try running Brent Ozar's First Responder Kit[^] on the server to see if there are any obvious errors.

You mention that the size of the data has increased. Does it now exceed the server's available memory? If it keeps having to go back to disk to load the data, then that can dramatically slow things down. Especially if the data isn't on an SSD.



"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer

GeneralRe: Database suddenly slow Pin
Super Lloyd18-Sep-19 21:47
memberSuper Lloyd18-Sep-19 21:47 
GeneralRe: Database suddenly slow Pin
Mycroft Holmes19-Sep-19 14:14
memberMycroft Holmes19-Sep-19 14:14 
QuestionI need this windows odbc driver Pin
Member 1458760611-Sep-19 9:00
memberMember 1458760611-Sep-19 9:00 
AnswerRe: I need this windows odbc driver Pin
OriginalGriff11-Sep-19 9:01
protectorOriginalGriff11-Sep-19 9:01 
GeneralRe: I need this windows odbc driver Pin
Member 1458760611-Sep-19 9:16
memberMember 1458760611-Sep-19 9:16 
AnswerRe: I need this windows odbc driver Pin
Maciej Los11-Sep-19 9:47
protectorMaciej Los11-Sep-19 9:47 
QuestionLooking for some assistance with a query Pin
FrankLepkowski10-Sep-19 10:50
memberFrankLepkowski10-Sep-19 10:50 
AnswerRe: Looking for some assistance with a query Pin
MadMyche10-Sep-19 12:12
mveMadMyche10-Sep-19 12:12 
GeneralRe: Looking for some assistance with a query Pin
MadMyche11-Sep-19 2:56
mveMadMyche11-Sep-19 2:56 
GeneralRe: Looking for some assistance with a query Pin
FrankLepkowski11-Sep-19 5:15
memberFrankLepkowski11-Sep-19 5:15 
GeneralRe: Looking for some assistance with a query Pin
MadMyche11-Sep-19 7:28
mveMadMyche11-Sep-19 7:28 
QuestionNeed help mixing two queries in one... Pin
Joan M1-Sep-19 1:40
professionalJoan M1-Sep-19 1:40 
AnswerRe: Need help mixing two queries in one... Pin
Richard Deeming2-Sep-19 2:02
mveRichard Deeming2-Sep-19 2:02 
GeneralRe: Need help mixing two queries in one... Pin
Jörgen Andersson2-Sep-19 2:39
protectorJörgen Andersson2-Sep-19 2:39 
GeneralRe: Need help mixing two queries in one... Pin
Joan M2-Sep-19 11:24
professionalJoan M2-Sep-19 11:24 
GeneralRe: Need help mixing two queries in one... Pin
Jörgen Andersson2-Sep-19 20:27
protectorJörgen Andersson2-Sep-19 20:27 
GeneralRe: Need help mixing two queries in one... Pin
Joan M2-Sep-19 20:29
professionalJoan M2-Sep-19 20:29 

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.