Click here to Skip to main content
15,346,820 members
Home / Discussions / Database
   

Database

 
AnswerRe: Loading large amount of data with unacceptable time Pin
David O'Neil27-Apr-14 11:17
professionalDavid O'Neil27-Apr-14 11:17 
GeneralRe: Loading large amount of data with unacceptable time Pin
Amr Muhammed27-Apr-14 11:32
MemberAmr Muhammed27-Apr-14 11:32 
GeneralRe: Loading large amount of data with unacceptable time Pin
David O'Neil27-Apr-14 11:38
professionalDavid O'Neil27-Apr-14 11:38 
AnswerRe: Loading large amount of data with unacceptable time Pin
Mycroft Holmes27-Apr-14 12:54
professionalMycroft Holmes27-Apr-14 12:54 
GeneralRe: Loading large amount of data with unacceptable time Pin
Amr Muhammed27-Apr-14 19:28
MemberAmr Muhammed27-Apr-14 19:28 
GeneralRe: Loading large amount of data with unacceptable time Pin
Mycroft Holmes27-Apr-14 21:54
professionalMycroft Holmes27-Apr-14 21:54 
GeneralRe: Loading large amount of data with unacceptable time Pin
Amr Muhammed29-Apr-14 13:11
MemberAmr Muhammed29-Apr-14 13:11 
AnswerRe: Loading large amount of data with unacceptable time Pin
V.28-Apr-14 0:01
professionalV.28-Apr-14 0:01 
How are the tables defined? That might help us defining a solution.
there are some assumptions we could make like is the share id unique? are they sequential? etc...


However let's get a few things straight.
- Looping a resultset to check for results is not a very good idea and will be slow.
- Returning a million records let's say will be slow, no matter what. Even if your database could build the resultset in milliseconds it still needs to send that data through a wire somehow. (that's why they invented paging Wink | ;) ) IOW if you can improve the queries, you might still be in trouble and in need of an alternate solution.
V.

(MQOTD rules and previous solutions)

GeneralRe: Loading large amount of data with unacceptable time Pin
Amr Muhammed29-Apr-14 13:06
MemberAmr Muhammed29-Apr-14 13:06 
GeneralRe: Loading large amount of data with unacceptable time Pin
V.30-Apr-14 23:45
professionalV.30-Apr-14 23:45 
AnswerRe: Loading large amount of data with unacceptable time Pin
jschell28-Apr-14 8:16
Memberjschell28-Apr-14 8:16 
GeneralRe: Loading large amount of data with unacceptable time Pin
Amr Muhammed29-Apr-14 13:00
MemberAmr Muhammed29-Apr-14 13:00 
GeneralRe: Loading large amount of data with unacceptable time Pin
Mycroft Holmes29-Apr-14 13:06
professionalMycroft Holmes29-Apr-14 13:06 
GeneralRe: Loading large amount of data with unacceptable time Pin
Amr Muhammed29-Apr-14 13:12
MemberAmr Muhammed29-Apr-14 13:12 
GeneralRe: Loading large amount of data with unacceptable time Pin
David O'Neil29-Apr-14 13:22
professionalDavid O'Neil29-Apr-14 13:22 
GeneralRe: Loading large amount of data with unacceptable time Pin
jschell29-Apr-14 14:33
Memberjschell29-Apr-14 14:33 
QuestionHow do I pass parameters from one jquery tab to another? Pin
samflex25-Apr-14 17:32
Membersamflex25-Apr-14 17:32 
AnswerRe: How do I pass parameters from one jquery tab to another? Pin
Kornfeld Eliyahu Peter26-Apr-14 23:42
professionalKornfeld Eliyahu Peter26-Apr-14 23:42 
GeneralRe: How do I pass parameters from one jquery tab to another? Pin
samflex27-Apr-14 5:53
Membersamflex27-Apr-14 5:53 
Questionscript to delete related rows without cascade Pin
Nico Haegens25-Apr-14 1:57
professionalNico Haegens25-Apr-14 1:57 
AnswerRe: script to delete related rows without cascade Pin
Mycroft Holmes25-Apr-14 13:16
professionalMycroft Holmes25-Apr-14 13:16 
GeneralRe: script to delete related rows without cascade Pin
Nico Haegens25-Apr-14 23:54
professionalNico Haegens25-Apr-14 23:54 
GeneralRe: script to delete related rows without cascade Pin
Mycroft Holmes26-Apr-14 0:33
professionalMycroft Holmes26-Apr-14 0:33 
GeneralRe: script to delete related rows without cascade Pin
Nico Haegens26-Apr-14 4:41
professionalNico Haegens26-Apr-14 4:41 
GeneralRe: script to delete related rows without cascade Pin
Mycroft Holmes26-Apr-14 13:46
professionalMycroft Holmes26-Apr-14 13:46 

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.