Click here to Skip to main content
15,499,571 members
Home / Discussions / Database
   

Database

 
GeneralRe: In-memory database with acid transactions and high availability Pin
OriginalGriff29-Jan-22 0:08
mveOriginalGriff29-Jan-22 0:08 
GeneralRe: In-memory database with acid transactions and high availability Pin
Meysam Toluie29-Jan-22 0:25
MemberMeysam Toluie29-Jan-22 0:25 
QuestionSQL Server round trip issue between server and client pc Pin
Mou_kol1-May-21 7:35
MemberMou_kol1-May-21 7:35 
AnswerRe: SQL Server round trip issue between server and client pc Pin
Mycroft Holmes1-May-21 12:57
professionalMycroft Holmes1-May-21 12:57 
AnswerRe: SQL Server round trip issue between server and client pc Pin
Gerry Schmitz1-May-21 18:12
mveGerry Schmitz1-May-21 18:12 
GeneralRe: SQL Server round trip issue between server and client pc Pin
Mycroft Holmes2-May-21 13:24
professionalMycroft Holmes2-May-21 13:24 
GeneralRe: SQL Server round trip issue between server and client pc Pin
Gerry Schmitz2-May-21 19:53
mveGerry Schmitz2-May-21 19:53 
QuestionSqlServer (and ADO.NET) mystery... Pin
Super Lloyd27-Apr-21 20:19
MemberSuper Lloyd27-Apr-21 20:19 
I have a large parameterised SQL query, on SQL Server

When I run it in SQL Server Management Studio (with SQL, doh) or in LinqPad (use C# Linq to Sql) then it runs fast.

If I ran it meself in my console app whether with EFCore/Linq Query or even a SqlCommand (and SQL Text) it is horrendously slow... even though I use the same parameter for every tests... (you know, if it created a stupid index for the query or something)

I have no clue what else I can do to check/fix that... Frown | :(
A new .NET Serializer
All in one Menu-Ribbon Bar
Taking over the world since 1371!


modified 28-Apr-21 1:25am.

AnswerRe: SqlServer (and ADO.NET) mystery... Pin
Richard Deeming27-Apr-21 23:11
mveRichard Deeming27-Apr-21 23:11 
GeneralRe: SqlServer (and ADO.NET) mystery... Pin
Super Lloyd27-Apr-21 23:42
MemberSuper Lloyd27-Apr-21 23:42 
AnswerRe: SqlServer (and ADO.NET) mystery... Pin
Mycroft Holmes28-Apr-21 12:46
professionalMycroft Holmes28-Apr-21 12:46 
QuestionInterval schedule Pin
Member 1462398929-Apr-21 3:56
MemberMember 1462398929-Apr-21 3:56 
AnswerRe: Interval schedule Pin
Victor Nijegorodov27-Apr-21 21:45
MemberVictor Nijegorodov27-Apr-21 21:45 
AnswerRe: Interval schedule Pin
Richard Deeming27-Apr-21 23:08
mveRichard Deeming27-Apr-21 23:08 
GeneralRe: Interval schedule Pin
Member 1462398929-Apr-21 3:38
MemberMember 1462398929-Apr-21 3:38 
QuestionRetail inventory management DB Design Pin
vineet123456713-Apr-21 0:42
Membervineet123456713-Apr-21 0:42 
AnswerRe: Retail inventory management DB Design Pin
Victor Nijegorodov13-Apr-21 1:54
MemberVictor Nijegorodov13-Apr-21 1:54 
AnswerRe: Retail inventory management DB Design Pin
RedDk13-Apr-21 13:10
MemberRedDk13-Apr-21 13:10 
QuestionRe: Retail inventory management DB Design Pin
Eddy Vluggen13-Apr-21 14:00
professionalEddy Vluggen13-Apr-21 14:00 
AnswerRe: Retail inventory management DB Design Pin
Mycroft Holmes14-Apr-21 14:32
professionalMycroft Holmes14-Apr-21 14:32 
QuestionConvert date, did I go too far Pin
jkirkerx8-Apr-21 13:50
professionaljkirkerx8-Apr-21 13:50 
AnswerRe: Convert date, did I go too far Pin
Victor Nijegorodov8-Apr-21 21:22
MemberVictor Nijegorodov8-Apr-21 21:22 
AnswerRe: Convert date, did I go too far Pin
Richard Deeming8-Apr-21 23:03
mveRichard Deeming8-Apr-21 23:03 
GeneralRe: Convert date, did I go too far Pin
jkirkerx9-Apr-21 7:14
professionaljkirkerx9-Apr-21 7:14 
GeneralRe: Convert date, did I go too far Pin
Mycroft Holmes9-Apr-21 13:21
professionalMycroft Holmes9-Apr-21 13: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.