----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Shekhar Message 3 in Discussion Hi sampath, Thanks for your reply, I am processing text message, once the content is processed and stored in variables, tabales are retrieved and updated corresponding to particular message. I am pasting the message example here :79:/HSMT/ATSP :79:/HVRN/002 :79:/HMDE/R :79:/HSEQ/00000023 :79:/HRSQ/00000002 :79:/HFPI/958 :79:/HDPI/958 :79:/ITXN/JDR0000652 :20:206 :79:/CTXS/I :79:/CPTS/Y :79:/CCTS/Y :79:/SSCH/20030428093303490243 :79:/CTXT/DEL 206 value of :20:206 is searched in specific tables and once obtaining the records series of updations are done....Let me tell how the messages are retrieved, based on Status "N" of message in database messages are retrieved, it could fetch more than 1000 message and in a forloop messages are processed, and every hit to database will request new connection to database, process is transaction based for each message, hope i given sufficient info...if u could give me some tips on performance and timeout error, i will be greatfull, thanks ----------------------------------------------------------- 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]
