I have directory i am working on and I cannot find why its so dog slow.
it loads up fine at first, then it dies on first use, then it flies.
it builds the radiobuttonlist items quickly on the fly. just not sure how to speed it up. i guess i will have to add a spinner to it.
here is the sqldataadapter select
Select [id],[EID],[FACorStaff],[Department], [Schools],[EName],[etitle],(select CASE WHEN LEN(email) > 0 THEN 'Email' ELSE '' END) as yesemail,[email],[EXT],[Active],(select CASE WHEN LEN(eweb) > 0 THEN 'Website' ELSE '' END) as yesweb,[eweb] FROM [DirectoryInfo]
where active = -1 and Schools like '%' + @hs + '%' and (FACorStaff like'%' + @facstaff + '%' and FACorStaff like'%' + @facstaff + '%') and(Department like '%' + @hs + '%' or FACorStaff like'%' + @facstaff1 + '%') and ((Department like '%' + @gradelevel +
...
Go to the complete details ...