On Mon, Jul 4, 2011 at 12:42 PM, V G wrote: > How about I ask you to drive a steel nail into ironwood with a hammer mad= e > out of wax? > > Are you a bad workman? Hmm. Probably. > If you start hammering with that instead of realizing that the wax is for lubricating the nail even if it has a shape of a hammer, then yes, you are :-) But dropping the jokes, what we are trying to point out is that something i= s probably wrong in either the software specs or the implementation if you tr= y to display few thousands records for each query. Usually customer does not want to read all these records manually but to do something with the selected records -- statistics for example or do some further actions, so all can store the results in temporary db leaving the data on the server side. And if you really need those records down, then either you need a pag= e by page view (good example how Google search displays on your screen), or a download facility where you can spend some time to download all records to = a suitable file format, plus you do not need to feed up a datagrid view which is probably just as resource hungry as the query itself. Tamas > -- > http://www.piclist.com PIC/SX FAQ & list archive > View/change your membership options at > http://mailman.mit.edu/mailman/listinfo/piclist > --=20 int main() { char *a,*s,*q; printf(s=3D"int main() { char *a,*s,*q; printf(s=3D%s%s%s, q=3D%s%s%s%s,s,q,q,a=3D%s%s%s%s,q,q,q,a,a,q); }", q=3D"\"",s,q,q,a=3D"\\",q,q,q,a,a,q); } --=20 http://www.piclist.com PIC/SX FAQ & list archive View/change your membership options at http://mailman.mit.edu/mailman/listinfo/piclist .