Click here to Skip to main content
15,890,512 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
AnswerRe: Difference between .net2.0 redist and IDE? Pin
Ed.Poore7-Jun-06 12:05
Ed.Poore7-Jun-06 12:05 
QuestionLoading dynamic assembly. Pin
webC#4-Jun-06 18:51
webC#4-Jun-06 18:51 
AnswerRe: Loading dynamic assembly. Pin
Hesham Amin4-Jun-06 21:17
Hesham Amin4-Jun-06 21:17 
GeneralRe: Loading dynamic assembly. Pin
phanikumar.kanumilli5-Jun-06 23:36
phanikumar.kanumilli5-Jun-06 23:36 
Questiongdwrapper Pin
jkirkerx4-Jun-06 11:04
professionaljkirkerx4-Jun-06 11:04 
Questionselecting a row in datagrid Pin
Siva Myneni2-Jun-06 18:48
Siva Myneni2-Jun-06 18:48 
QuestionDataSet vs. DB query Pin
Rabbit172-Jun-06 9:07
Rabbit172-Jun-06 9:07 
AnswerRe: DataSet vs. DB query Pin
Stephan Samuel2-Jun-06 10:23
Stephan Samuel2-Jun-06 10:23 
You can do selects and joins on DataSets, but it's more complicated and annoying than doing it on the database.

I don't understand why a simple inner join takes noticably longer than a flat query. It certainly has nothing to do with your connection to the database. More likely, you've got a poorly-optimized database. Your previous question was about MySQL, so I'll assume that's what you're using. MySQL should be able to do a 1-column inner join on a million rows with a proper index in less time than a table scan (which is what you'd get if you did select name, id) from each table. I don't respect MySQL very much, but it's a hell of a lot more competent than to whimper on a 1-column inner join.

What's your DB look like?

AnswerRe: DataSet vs. DB query Pin
Guffa2-Jun-06 10:35
Guffa2-Jun-06 10:35 
QuestionMySQL Query help! Pin
Rabbit172-Jun-06 8:55
Rabbit172-Jun-06 8:55 
AnswerRe: MySQL Query help! Pin
Stephan Samuel2-Jun-06 10:16
Stephan Samuel2-Jun-06 10:16 
QuestionTesting user-interface Pin
Tomerland1-Jun-06 22:51
Tomerland1-Jun-06 22:51 
AnswerRe: Testing user-interface Pin
Ed.Poore2-Jun-06 6:25
Ed.Poore2-Jun-06 6:25 
AnswerRe: Testing user-interface Pin
Stephan Samuel2-Jun-06 6:43
Stephan Samuel2-Jun-06 6:43 
AnswerRe: Testing user-interface Pin
Jim Conigliaro2-Jun-06 8:37
Jim Conigliaro2-Jun-06 8:37 
GeneralRe: Testing user-interface Pin
Stephan Samuel2-Jun-06 10:25
Stephan Samuel2-Jun-06 10:25 
GeneralRe: Testing user-interface Pin
Tomerland19-Jun-06 2:42
Tomerland19-Jun-06 2:42 
QuestionRepaint a application [modified] Pin
Resolver181-Jun-06 19:11
Resolver181-Jun-06 19:11 
AnswerRe: Repaint a application [modified] Pin
Stephan Samuel2-Jun-06 6:00
Stephan Samuel2-Jun-06 6:00 
GeneralRe: Repaint a application [modified] Pin
Guffa2-Jun-06 6:32
Guffa2-Jun-06 6:32 
NewsRe: Repaint a application [modified] Pin
Resolver184-Jun-06 20:37
Resolver184-Jun-06 20:37 
QuestionProject location is not fully trusted Pin
hemrk1-Jun-06 6:01
hemrk1-Jun-06 6:01 
AnswerRe: Project location is not fully trusted Pin
Ed.Poore2-Jun-06 6:17
Ed.Poore2-Jun-06 6:17 
QuestionIdentifing unmanaged code [modified] Pin
Praveen_S1-Jun-06 3:24
Praveen_S1-Jun-06 3:24 
AnswerRe: Identifing unmanaged code [modified] Pin
Stephan Samuel1-Jun-06 6:59
Stephan Samuel1-Jun-06 6: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.