help me about speed of loading data ...
-
I have a 100MB database of SQLServer. When I made a datagridview using DatagridViewColumnCombox in order that user can choose an item in combobox. When I choose an item, it seems to load data into combobox column. It cause my app running so slowly although this column contains a field about over 1000 records.... Somebody could help me explain why VS.NET uses cache but my app runs slowly I assume that if I made a combo box and then attached it into datagridview, it ưould seem slower. But, I don't know how to do it.... Sorry about my poor English Thanks in advance ...
It seem to be a solution or an answer.
-
I have a 100MB database of SQLServer. When I made a datagridview using DatagridViewColumnCombox in order that user can choose an item in combobox. When I choose an item, it seems to load data into combobox column. It cause my app running so slowly although this column contains a field about over 1000 records.... Somebody could help me explain why VS.NET uses cache but my app runs slowly I assume that if I made a combo box and then attached it into datagridview, it ưould seem slower. But, I don't know how to do it.... Sorry about my poor English Thanks in advance ...
It seem to be a solution or an answer.
phantanagu wrote:
When I choose an item, it seems to load data into combobox column.
It *seems* to ? What code have you written, that you're not sure if it does, or not ? If you take the SQL that's being run, and run it in SQL Server, how fast is it ?
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
-
phantanagu wrote:
When I choose an item, it seems to load data into combobox column.
It *seems* to ? What code have you written, that you're not sure if it does, or not ? If you take the SQL that's being run, and run it in SQL Server, how fast is it ?
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog "I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
Christian Graus wrote:
It *seems* to ? What code have you written, that you're not sure if it does, or not ?
I only assign datasource to combobox column using dataset object,I don't write any code. Because list of items appears slow so I think everytime I select an item in new row, combo box also loads data.
Christian Graus wrote:
If you take the SQL that's being run, and run it in SQL Server, how fast is it ?
I am sure that if I run it in SQLServer, it makes me content with speed. If I use a favourite combox, loading of data is OK. But when using DatagridColumnComboBox, I confuse it...
It seem to be a solution or an answer.
-
Christian Graus wrote:
It *seems* to ? What code have you written, that you're not sure if it does, or not ?
I only assign datasource to combobox column using dataset object,I don't write any code. Because list of items appears slow so I think everytime I select an item in new row, combo box also loads data.
Christian Graus wrote:
If you take the SQL that's being run, and run it in SQL Server, how fast is it ?
I am sure that if I run it in SQLServer, it makes me content with speed. If I use a favourite combox, loading of data is OK. But when using DatagridColumnComboBox, I confuse it...
It seem to be a solution or an answer.
Did you write code to load the data or you've drag/drooped in VS.NET a connection/dataset and so on?