Asp Forum
Home
|
Login
|
Register
|
Search
Forums
>
microsoft.public.scripting.vbscript
セイコー アウトレット
bernhard stahl
12/25/2013 1:15:00 PM
辺真一(ピョンジンイル)編集長は13日夜、BS日テレの「深層NEWS」に出演し、北朝鮮の張成沢(チャンソンテク)前国防委 <a href=
http://www.canosuperior.c...
ブーツ</a> 員会副委員長のスピード処刑について、「金正日(キムジョンイル)総書 <a href=
http://www.canosuperior.com/>ア&a...
ブーツ</a> 記の命日(17日)を前に、早め <a href=
http://www.canosuperior.com/>http://www.canosuperior.com/...
に体制を固めようとした。張氏支持の残党の動きを封じ込める狙いもあったのでは」と述べた。粛清の理 <a href=
http://www.viviennesign.com/>ヴィヴィアンウエストウッド...
由については「(経済再建を <a href=
http://www.viviennesign.com/>ヴィヴィアンウエストウッド...
担っていた)張氏が、長老グループ <a href=
http://www.viviennesign.com/>http://www.viviennesign.com/...
などの既得権に手を突っ込んだからでは」と分析した。また、無慈悲な処刑を行ったことで、南北や米朝、中 <a href=
http://www.normanrschultz.o...
ブーツ 激安</a> 朝関係にも影響する可能性があり、「来年は長距離弾道ミサイル <a href=
http://www.normanrschultz.o...
アウトレット</a> の発射、核実験というあしきパターンもあり得る」と語 <a href=
http://www.normanrschultz.org/>http://www.normanrschultz.org/...
った。
朝鮮の金正恩(キムジョンウン)第1書記 <a href=
http://www.blessingstudio.com/>ケイトスペー&a...
店舗</a> の叔父で実質ナンバー2だった張成沢(チャンソンテク)前 <a href=
http://www.blessingstudio.com/>ケイトスペー&a...
財布</a> 国防副委員長の最後の姿は、あまりにも <a href=
http://www.blessingstudio.com/>http://www.blessingstudio.com/...
惨めなものだった。特別軍事裁判 <a href=
http://www.auroralimofl.com...
腕時計</a> の被告人席で両手首に手錠のようなものをはめられ、国家安全保衛 <a href=
http://www.auroralimofl.com...
腕時計</a> 部(秘密警察)要員とみられる2人に首や腕をつかまれたまま <a href=
http://www.auroralimofl.com/>http://www.auroralimofl.com/...
立っている張氏の姿は、北朝鮮の中枢にいた人物とは思えないほどだ。朝 <a href=
http://www.auppix.o...
スニーカー</a> 鮮労働党の機関紙「労働新聞」が13日に公開した法廷の <a href=
http://www.auppix.o...
アグ ブーツ</a> 写真を見ると、張氏は普 <a href=
http://www.auppix.org/>http://www.auppix.org/...
段と同じように紺色の人民服姿で黒い色が入った眼鏡をかけているが、金第1書記に随行して公 <a href=
http://www.wichitarcc.org/>セイコ&a...
時計</a> 活動をしていたころと比べると、髪も <a href=
http://www.wichitarcc.org/>セイコ&a...
時計</a> 薄くなり明らかにやつれた様子だ。腰を若干折り曲げうつむいて目を閉じた姿は、全てを諦めただ処 <a href=
http://www.wichitarcc.org/>http://www.wichitarcc.org/...
刑されるのを待っているかのようだ。
2 Answers
Tom Garth
7/4/2007 2:10:00 PM
0
I would start by executing the exact same procedure call in a query window.
--
Tom Garth
"Oldman" wrote:
> Great! Well the first thing you mention is already taken care of. I am
> using SqlClient.
> I will try the CLR profiler on the client and on the server. I really
> believe the problem lies on the server though because I have the same exact
> database running locally and it runs just fine when connecting and querying
> against that instance.
>
> Thanks,
>
> Chris
>
> "Manish Bafna" wrote:
>
> > Hi,
> > The first is that if you are connecting to SQL Server from ADO.NET, you
> > should be using SqlClient instead of OleDb.Benefits of SQLClient over oledb
> > are:
> > 1) SQLClient certainly is faster than OLEDB; the Emperor has clothes
> > after all
> > 2) SQLClient has a larger managed heap footprint
> > 3) A larger managed heap footprint does not necessarily mean a slower
> > performing application: in this case, it means the opposite (but this isn???t
> > always the case ??? try a String vs StringBuilder example)
> > 4) The CLRProfiler is a powerful tool for inspecting your
> > application???s internal behaviour
> > For more details refer below link:
> >
http://codebetter.com/blogs/grant.killian/archive/20...
> > --
> > Hope this helps.
> > Thanks and Regards.
> > Manish Bafna.
> > MCP and MCTS.
> >
> >
> >
> > "Oldman" wrote:
> >
> > > I have this stored procedure on a SQL 2005 database that when invoked from
> > > query analyzer or SQL Server Management studio runs in 2 seconds.
> > > However, the following code times out on the executeScalar call:
> > >
> > > DbCommand cmd = cnn.CreateCommand();
> > > cmd.CommandText = "spc_search_items_count";
> > > cmd.CommandType = CommandType.StoredProcedure;
> > > cmd.CommandTimeout = UtilFuncs.DbScaledTimeout(45,
> > > SysTimeoutScalars.Items);
> > >
> > > //-- Create parameters --//
> > > DBProvider.CreateParam(cmd, "vchSearchString",
> > > DbType.AnsiString, srchString);
> > > DBProvider.CreateParam(cmd, "intUserID", DbType.Int32,
> > > nUserID);
> > > DBProvider.CreateParam(cmd, "intBatchID", DbType.Int32,
> > > nBatchID);
> > > DBProvider.CreateParam(cmd, "intStatusID", DbType.Int32,
> > > nStatusID);
> > > DBProvider.CreateParam(cmd, "intCategoryID", DbType.Int32,
> > > nCategID);
> > >
> > > cnn.Open();
> > >
> > > int nCount;
> > > object obj = cmd.ExecuteScalar();
> > > if(obj != null)
> > > nCount = Convert.ToInt32(obj);
> > > else
> > > nCount = 0;
> > >
> > > When monitoring SQL Server I see the process ID using just CPU and the
> > > details say: TTT.dbo.spc_search_items_count;1
> > >
> > > Does anybody have any advise of where the problem could lie? I have never
> > > had this happen before; where invoking something through ADO.NET is any
> > > different than invoking the stored procedure through other means.
Oldman
7/5/2007 1:00:00 PM
0
I did this. It only takes 2 seconds. That is what is baffling.
It is only slow when called through ADO.NET.
Another datapoint is that this stored proc is only returning a count so
there should not be a wire issue with regards to the size of the data being
returned.
"Tom Garth" wrote:
> I would start by executing the exact same procedure call in a query window.
> --
> Tom Garth
>
>
> "Oldman" wrote:
>
> > Great! Well the first thing you mention is already taken care of. I am
> > using SqlClient.
> > I will try the CLR profiler on the client and on the server. I really
> > believe the problem lies on the server though because I have the same exact
> > database running locally and it runs just fine when connecting and querying
> > against that instance.
> >
> > Thanks,
> >
> > Chris
> >
> > "Manish Bafna" wrote:
> >
> > > Hi,
> > > The first is that if you are connecting to SQL Server from ADO.NET, you
> > > should be using SqlClient instead of OleDb.Benefits of SQLClient over oledb
> > > are:
> > > 1) SQLClient certainly is faster than OLEDB; the Emperor has clothes
> > > after all
> > > 2) SQLClient has a larger managed heap footprint
> > > 3) A larger managed heap footprint does not necessarily mean a slower
> > > performing application: in this case, it means the opposite (but this isn???t
> > > always the case ??? try a String vs StringBuilder example)
> > > 4) The CLRProfiler is a powerful tool for inspecting your
> > > application???s internal behaviour
> > > For more details refer below link:
> > >
http://codebetter.com/blogs/grant.killian/archive/20...
> > > --
> > > Hope this helps.
> > > Thanks and Regards.
> > > Manish Bafna.
> > > MCP and MCTS.
> > >
> > >
> > >
> > > "Oldman" wrote:
> > >
> > > > I have this stored procedure on a SQL 2005 database that when invoked from
> > > > query analyzer or SQL Server Management studio runs in 2 seconds.
> > > > However, the following code times out on the executeScalar call:
> > > >
> > > > DbCommand cmd = cnn.CreateCommand();
> > > > cmd.CommandText = "spc_search_items_count";
> > > > cmd.CommandType = CommandType.StoredProcedure;
> > > > cmd.CommandTimeout = UtilFuncs.DbScaledTimeout(45,
> > > > SysTimeoutScalars.Items);
> > > >
> > > > //-- Create parameters --//
> > > > DBProvider.CreateParam(cmd, "vchSearchString",
> > > > DbType.AnsiString, srchString);
> > > > DBProvider.CreateParam(cmd, "intUserID", DbType.Int32,
> > > > nUserID);
> > > > DBProvider.CreateParam(cmd, "intBatchID", DbType.Int32,
> > > > nBatchID);
> > > > DBProvider.CreateParam(cmd, "intStatusID", DbType.Int32,
> > > > nStatusID);
> > > > DBProvider.CreateParam(cmd, "intCategoryID", DbType.Int32,
> > > > nCategID);
> > > >
> > > > cnn.Open();
> > > >
> > > > int nCount;
> > > > object obj = cmd.ExecuteScalar();
> > > > if(obj != null)
> > > > nCount = Convert.ToInt32(obj);
> > > > else
> > > > nCount = 0;
> > > >
> > > > When monitoring SQL Server I see the process ID using just CPU and the
> > > > details say: TTT.dbo.spc_search_items_count;1
> > > >
> > > > Does anybody have any advise of where the problem could lie? I have never
> > > > had this happen before; where invoking something through ADO.NET is any
> > > > different than invoking the stored procedure through other means.
Servizio di avviso nuovi messaggi
Ricevi direttamente nella tua mail i nuovi messaggi per
セイコー アウトレット
Inserendo la tua e-mail nella casella sotto, riceverai un avviso tramite posta elettronica ogni volta che il motore di ricerca troverà un nuovo messaggio per te
Il servizio è completamente GRATUITO!
x
Login to ForumsZone
Login with Google
Login with E-Mail & Password