Performance of webpage

[farogh haider]

Hi, I use a gridview with checkbox & emailid for sending newsletter, which bind with sqlserver 2000 table, that contains more than 2000 records, so when page load it takes so much time. Please send me better solution for sending newsletter.

[Brij]

It's better if you load the database in the Cache when application starts and then use the cached database.It'll help in better performance

Cheers!! Brij Check My Latest Article

[Satish32]

I believe you are using paging feature for displaying 2000 rows in grid view. Transfer 2000 rows across the network will take long time and application becomes very slow. Instead of that you can write a stored procedure, which will fetch only those rows which are supposed to display on a particular page ( suppose if page size is 20 and User clicks on 3rd page your stored procedure should fetch the rows from 41 to 60 records) you can find variety of stored procedures on the net for doing this, just Google.

Satish

[Xmen Real]

bind with SqlDataSource, much faster than doing things manually

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L %^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2 W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN% Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i’TV.C\y<pŠjxsg-b$f4ia> -------------------------------------------------------- 128 bit encrypted signature, crack if you can