----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Mrinal Message 6 in Discussion Hi Sundar , Hope this may help u in resolving the situation mentioned by you : What i have understood is that you are having online query builder , through the medium of listboxes that lists TableName , FieldName(s) etc. and based on user selection you form query string and pass it on to the database for filling up a Dataset . 1. Now since clicking on TableName List box lists all the columns etc. , u just need to do this for first time , as this is associated with DB schema , which doesn't changes once freezed , so after first time when u get values , just store it in Cache and keep on getting values from there rather than pinging DB , it will have huge performance impact . 2. Rather than going for a Dynamic Query , to be passed over to DB , implement the same in form of Store Procedure and Pass all these values as parameters , which remains pre compiled at database and will give u relevant result much faster , infact that is in case u r really particular about Data Staleness and need complete refreshed values at moment . Also store the values based on Primary Key in Local Cache and check it in cache before going to Database , that will be much faster . 3. Also if ur not much concerned about Data Staleness , then u can just load Dataset for first time and then based on your selection u can form Dataviews or Relevant Subsets out of it , it will again be much faster than pinging the database . Hope it helps , if u need some implementation related specific details , let me know , regards , Mrinal ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
