CodeVerge.Net Beta


   Explore    Item Entry    Members      Register  Login  
NEWSGROUP
.NET
Algorithms-Data Structures
Asp.Net
C Plus Plus
CSharp
Database
HTML
Javascript
Linq
Other
Regular Expressions
VB.Net
XML

Free Download:




Zone: > NEWSGROUP > Asp.Net Forum > starter_kits_and_source_projects.portal_starter_kit Tags:
Item Type: NewsGroup Date Entered: 10/14/2003 12:20:32 PM Date Modified: Subscribers: 0 Subscribe Alert
Rate It:
(NR, 0)
XPoints: N/A Replies: 3 Views: 56 Favorited: 0 Favorite
Can Reply:  No Members Can Edit: No Online: Yes
4 Items, 1 Pages 1 |< << Go >> >|
Johnny B
Asp.Net User
connection string - packet size10/14/2003 12:20:32 PM

0/0

Hi

I read this the today somewhere which I thought was interesting .... the default packet size that the database sends to ADO.net is 8192 bytes however when you are just returning the results of a query that returns an email address or a user name for example a much smaller packet size will help improve performance.

I have done the recommendation of adding to the connection string definition in webconfig the parameter "packet size=512" .

Any comments on this ... can someone point out a downside to this .... no doubt there is one!!!!

Johnny B
Johnny B
Asp.Net User
Re: connection string - packet size10/27/2003 1:23:51 PM

0/0

No takers !!

??
wunderkinder
Asp.Net User
Re: connection string - packet size10/27/2003 3:08:36 PM

0/0

I guess I would agree that for most portal applications, setting the PacketSize to 512 would be sufficient. However, if an application is using a db to store large amounts of text, images, or even files, then having a larger PacketSize setting would be a good idea. A person could place a second connection string setting in web.config that is used for sending/retrieving these larger amounts of data.
Jared Livingston
MrLivingston.com - Livingston Family Website

Test/Demo site - moonmark.com
Johnny B
Asp.Net User
Re: connection string - packet size10/28/2003 7:49:45 AM

0/0

Ah ... a second connection string .... that's a good idea.

J
4 Items, 1 Pages 1 |< << Go >> >|


Free Download:

Books:
Beginning ASP.NET Databases Using VB.NET: Written and Tested for Final Release of .NET V.1.0 Authors: John Kauffman, Fabio Claudio Ferracchiati, Brian Matsik, Jesudas Chinnathampi, Eric N. Mintz, Jan D. Narkiewicz, Kent Tegels, Donald Xie, John M. West, James Greenwood, Pages: 480, Published: 2003
Beginning VB 2008 Databases: From Novice to Professional Authors: Vidya Vrat Agarwal, James Huddleston, Pages: 409, Published: 2008
Database Programming with C# Authors: Carsten Thomsen, Pages: 667, Published: 2002
IIS 6: The Complete Reference Authors: Hethe Henrickson, Scott Hofmann, Pages: 720, Published: 2003
Professional ADO.NET 2: Programming with SQL Server 2005, Oracle, and MySQL Authors: Wallace B. McClure, Gregory A. Beamer, John J. Croft, John J. Croft, IV, J. Ambrose Little, Bill Ryan, Phil Winstanley, David Yack, Jeremy Zongker, Pages: 614, Published: 2005
Microsoft Visual C# .NET 2003 Kick Start: Kick Start Authors: Steven Holzner, Dan Fernandez, Pages: 624, Published: 2003
Microsoft SQL Server 2005 Integration Services Authors: Kirk Haselden, Trey Johnson, Pages: 717, Published: 2006
Visual Basic .NET Power Tools: Power Tools Authors: Evangelos Petroutsos, Richard Mansfield, Pages: 694, Published: 2003
Visual Basic .NET Power Coding Authors: Paul Kimmel, Pages: 708, Published: 2003
Beginning ASP.NET Databases Using C# Authors: Jesudas Chinnathampi, Clive Douglas Campbell, John Kauffman, Brian Matsik, Fabio Claudio Ferrachiati, Jan Narkewicz, Kent Tegels, Eric Mintz, Matt Butler, Pages: 453, Published: 2002

Web:
ConnectionStrings.com - How to connect to SQL Server 2000, 7.0 Find your SQL Server 2000, 7.0 connection string syntax and learn more ... NET Framework Data Provider for SQL Server sets the network packet size to 8192 ...
SqlConnection.PacketSize Property (System.Data.SqlClient) The following example creates a SqlConnection, including setting the Packet Size to 512 in the connection string. It displays the PacketSize and ...
SqlConnection.ConnectionString Property The ConnectionString is similar to an OLE DB connection string, but is not identical. .... Packet Size, 8192, Size in bytes of the network packets used to ...
SqlConnection Connection String Parameter Keywords & Values ... Packet Size. 8192. Size in bytes of the network packets used to ... Resetting the connection string resets all connection string values including the ...
C Sharp Gal: Connection String Tune Up I had maybe 15 minutes and I talked about Connection String settings. ... Packet Size is to the network Packet size of the SQL Server data provider. ...
Educate yourself about .NET SQL Server connection string syntax Tony Patton provides more details about SQL Server connection string syntax. ... Packet Size: The size of the network packets (in bytes) used to communicate ...
How To: SQL Connection String stored as XML [Archive] - Tech ... packet size=" & packet 'Now you can use your new connection string Dim mySqlConnection As New SqlConnection(myConnectionString) ...
iAnywhere.com - Connecting to a data source using a connection string If your application requires a connection string to connect to a data source, .... If PacketSize is specified, you will receive a message "Driver Not ...
Safari Books Online - 073562206X - Programming Microsoft® ADO.NET ... PacketSize, Int32, Returns the packet size used when communicating with SQL ... The ConnectionString property controls how the SqlConnection object will ...
connection string - packet size - ASP.NET Forums I have done the recommendation of adding to the connection string definition in webconfig the parameter "packet size=512" . ...




Search This Site:










creating namespace to customize menu control

fileupload.postedfile and ftp

a great day for asp.net world, paul wilson relases his multiple form webform as opensource

help

global functions

could not load file or assembly

asp.net page eating cpu

where to store the userproviderkey? cookie or session or cache

system.threading.threadabortexception and response.redirect

create a zip with asp.net and vb

"if" problem. what am i doing wrong? thank you.

unrecognized tag prefix 'asp' ??!!

very simple display problem

need a script to retrieve referring url and compare with list of authorized urls to allow entry

intranet engine

1) other styles/themes availible? 2) renders incorrectly in ff

3.0.7 image gallery js error

how can i export the data in datatable to word or excel using c# ?

unable to edit text

prevent module deletion from a tab

need some help writing a fileupload loop

show windows form designer generated code

datetime problem in vb.net

read viewstate in page_init

any work arounds?

treeview, populateondemand, and callbacks

displaying word files by streamreader

dropdownlist having no selected value "on occasion", typically during high load times

questions about contact manager (s)

menu control - disappears in subpages

 
All Times Are GMT