113 reputation
4
bio website
location
age
visits member for 1 year, 10 months
seen Aug 7 at 9:55

My experience is mostly Visual Basic .NET and ASP.NET.


Sep
24
awarded  Autobiographer
Jan
18
awarded  Scholar
Jan
18
accepted Speed up data transfer from db to application
Jan
18
comment Speed up data transfer from db to application
Not the really the answer, but it helped. Also Gulli Meels answer helped. Next step is to redesign data retrieval with filter before sending to sql instead of filtering after. Thanks all.
Jan
17
comment Speed up data transfer from db to application
349295 records.
Jan
17
comment Speed up data transfer from db to application
@dezso Yes, there is no where condition here. This table should show all tickets. I'm trying to get my customer to understand this is or will be a problem but I'm not there yet...
Jan
17
awarded  Editor
Jan
17
comment Speed up data transfer from db to application
added the SQL code.
Jan
17
revised Speed up data transfer from db to application
SQL Code added.
Jan
17
comment Speed up data transfer from db to application
I ran an fragmentation count query but I don't know if this is bad or not:
Jan
17
awarded  Student
Jan
17
asked Speed up data transfer from db to application
Jan
17
comment speed up data transfer from SQL server to application
SQL code is sent to the server then the wait starts for the data.
Jan
16
asked speed up data transfer from SQL server to application