asp.net - GridView + ObjectDataSource issue - equally bad performance for large and small result sets -


I was called to work on the old NET Legacy Web App. The performance was quite sub-crossed lately, because the amount of data in the system was quadruple. It was fine for the past 2 years.

This can talk to an archived procedure using an .xsd file that compresses the results adequately (though no paging) and feeds them in the gridview through the Object data source . / P>

The part can not be found around my head , was it taking approximately 7 seconds to load for 1 result, 140 or 1200 . For the results of the result, the second took a split second (to mark on the GridView page)

Using the SQL Profiler, we were able to see that the query takes 6.9 seconds. Runing the same query with the same parameter, taking 100 mms in SQL Management Studio, I have changed the parameters to make sure that it is not only a cached result, while the long wait time is reliable to be reproducible.

I know it must be done here, but for now I have only been trying to find an explanation for the last time why the page is performing equally

(Gridview's 'simple' performance is fine for their needs - there is no need to control HTML)

We have the same problem:

  1. Check if your statistics are up to date:
S Elect ObjectName = Object_Name (ind.object_id), IndexName = ind.name, StatisticsDate = STATS_DATE (ind.object_id, ind.index_id) SYS.INDEXES to STATS_DATE Ind order order (ind.object_id, ind SQL server drop cache: < / Li> 
 DBCC Drapliquin buffers DBCC FreePrechchai
  1. ">
  2. If no one does help , You can try implementing an SSMS query plan with signals such as "joining the internal LOOP" and "with (index = ...)".

Comments

Post a Comment

Popular posts from this blog

python - Overriding the save method in Django ModelForm -

I'm having trouble overriding a ModelForm save method. I get this error I'm: Exception type: TypeErier Exception Value: Save () found an unexpected keyword argument 'committed' My intentions include a form 3 fields Submit several values ​​for, then create an object for each combination of those areas, and to save each object file models.py class collarsult type (models.Model): id = model. AutoField (db_column = 'icontact_result_code_type_id', primary_key = true) callResult = models.ForeignKey ( 'CallResult', db_column = 'icontact_result_code_id') campaign = models.ForeignKey ( 'campaign', db_column = 'icampaign_id') CALLTYPE = models.ForeignKey ( 'CALLTYPE', db_column = 'icall_type_id') agent = models.BooleanField (db_column = 'bagent', default = true) teamLeader = models.BooleanField (db_column = 'bTeamLeader', default = true) active = models.BooleanField (db_column = Django.form...
Read more

html - CSS autoheight, but fit content to height of div -

I have a div in which there are three children- div in the left and middle div: float: left while true: float: true because it is my layout Actually will spoil, I've used ClearFix Hack: .cf {zoom: 1; }. Cf: First,. Cf: {content: ""; Display: Table; }. Cf: After {clear: both; } It still works, but I want to be the right div an indicator. So it should fill 100% of the parent unit of height. How can I complete this? PS is the full code: & Lt; / Div & gt; & Lt; Div class = "mobile_content" & gt; & Lt; H5 & gt; {{Data.titel}} & lt; / H5> & Lt; Table & gt; & Lt; TR & gt; & Lt; Th & gt; Komponist: & lt; / Th & gt; & Lt; TD & gt; {{Data.komponist}} & lt; / TD & gt; & Lt; / TR & gt; & Lt; TR & gt; & Lt; Th & gt; Instrument: & lt; / Th & gt; & Lt; TD & gt; {{Data.instrumente}} & lt; / TD & gt; & Lt; / TR & gt;...
Read more

qt - How to prevent QAudioInput from automatically boosting the master volume to 100%? -

I have been trying to use Qt5 multimedia to record audio with QAudioInput, however, when I see If QAudioInput is started, it increases the master volume of my sound device to 100%. How can I prevent QAudioInput from changing the master volume? My current development platform is Linux with PalsAdio (with flat audio disabled). How can I use QAudioInput : QAudioDeviceInfo device_info = QAudioDeviceInfo :: defaultInputDevice (); QAudio format format; Format.setSampleRate (44100); Format.setChannelCount (1); Format.setSampleSize (16); Format.setCodec ("Audio / PCM"); Format.setSampleType (QAudioFormat :: SignedInt); Format.setByteOrder (QAudioFormat :: LittleEndian); Std :: cout & lt; & Lt; Device_info.deviceName (). ToUtf8 (). ConstData () & lt; & Lt; Std :: endl; QAudioInput * default_device = new QAudioInput (device_info, format); QIODevice * default_io_device = default_device-> Start (); a QAudioInput.setVolume () method is not you I ...
Read more