DB/Reporting :: Database Communication Speed Optimizations?
Mar 25, 2011
I have a few questions regarding database speed issues, I want to learn more on this subject. I searched the internet a bit but could not find an answer that satisfied enough me so I thought i try here. I have used adodb for quite a while but never were in the need of doing it the fastest way. That changed a bit.Is there information on the internet or can you provide me with information that illustrates what the cost is of doing a while not .eof loop to populate a dropdownlistbox with a lot of values or using a different approach? what are the faster approaches? I understand it depends on the situation but i am interested in a summary of some ball park figures. Just to illustrate what is better to use in certain situations.
View 2 Replies
ADVERTISEMENT
Aug 9, 2009
I'm having some doubts on which communication protocol/platform would be better for my current development. The focus is on communication performance, and while reliability matters, I can handle a some packet loss. UDP sounds like the correct choice, but then the following question came up:
"What would be better, using a UDP socket directly in .NET, or using a UDP socket implemented in unmanaged C++ with a wrapper to .NET?"I'm quite sure that C++ is faster than .NET, and while the communication might be faster, I'm not sure if that performance improvement is not lost with all the C++-to-.NET wrapping?
Some info about the project I'll be using this on:
- The core of the project will be all made in VB.NET.
- There'll be a high packet sending/receiving volume (about 100-200/sec).
- There'll be many clients requesting data to the server.
- Network communication will be over a GB-LAN.
- Data is time sensitive, and some packet loss is accepted.
- Running on .NET 3.5.
View 3 Replies
Jun 19, 2009
I converted our project from .NET 2.0 to 3.5 and am looking for optimizations that can be done utilizing 3.5 framework. What are some of the things I can do with 3.5 as in Datastructures. using DataAccess apart from LINQ to SQL.
View 5 Replies
Jun 16, 2010
I think im going mad but can some show me what im missing, it must be some stupidly simple i just cant see the wood for the trees.BOTH side of this if then else statement are being executed?
Ive tried commenting out the true side and moving the condition to a seperate variable with the same result. However if i explicitly set the condition to 1=0 or 1=1 then the if then statement is operating as i would expect. i.e. only executing one side of the equation...
The only time ive seen this sort of thing is when the compiler has crashed and is no longer compiling (without visible indication that its not) but ive restarted studio with the same results, ive cleaned the solution, built and rebuilt with no change?
Dim dset As DataSet = New DataSet
If (CboCustomers.SelectedValue IsNot Nothing) AndAlso (CboCustomers.SelectedValue <> "") Then
Dim Sql As String = "Select sal.SalesOrderNo As SalesOrder,cus.CustomerName,has.SerialNo,
[code]....
View 4 Replies
Feb 4, 2010
Does the VB.NET 2008 compiler selectively optimize Select Case Statements?
For example, a Select Case Statement with a sufficient quantity of integer cases could be organized as a binary search.
I ask this because I am curious whether or not I should opt for a Select Case in place of If Statements with multiple Else If's where integers or other basic data types are being compared.
View 2 Replies
Nov 5, 2009
Are these results expected or am I conducting my benchmarks incorrectly: Benchmark: Query on 363,264 records takes Access 27s to run (Over network) ADO.net: 54 seconds (Over network) ASP.NET: 34s (Local on server) The last two have identical VB.net code. All three run the same query on the same DB.
View 1 Replies
Feb 21, 2012
How do i exactly check internet connection speed.I have searched around google and found out a method w/c will Download a file like 1mb size, then it will calculate the speed.
View 1 Replies
Dec 31, 2010
how do i check the bandwidth (download speed and possible upload speed) of a user in vb.net or php that uses my app or visits my site resp?
View 1 Replies
Nov 30, 2010
I have a codes that calculates DownLoad speed and UpLoad speed kb/s. I would like to implement this kind. I also want to put such kind of graph. Any article or links where can I start building my own like that.
View 2 Replies
Jul 29, 2009
i want to monitor the speed at which my system is currently Downloading and uploading. I dont have any idea how will it can be done.
View 6 Replies
Apr 25, 2011
How fast did the VB.net inserts a data in a Mssql database??
View 1 Replies
Jan 24, 2012
Basically needs to get the temp and the clock speed from a database and desplay it in a graph.
Here is a download of the project file : [URL] and if you can not be bothered downloading it here is a link to the code its self:[URL]
View 14 Replies
Jan 11, 2010
I've read that making a class sealed in C# is advisable in high-performance scenarios because it frees the compiler to make certain optimizations (e.g., inlining property getters) that it wouldn't be able to make otherwise. Is the same true for NotInheritable in VB.NET?
View 1 Replies
Jan 4, 2012
i want to check for the lan speed and put this speed value in a progress bar.
for example:
[==== ] the lan speed now is 23 KB/s
and there is another problem is if there are a LAN and a WiFi adapter in the same time how do i check for the speed for both adapters
View 1 Replies
Apr 21, 2008
I want to move my programs and the database to another computer and hard-disks. It looks to me as though I nearly have to re-create the controls and rewrite some of the code to make it so the programs still work after the move. At least with ODBC all I would change was the DSN definitions external to the programs. Is there an easy way to move or rename a database without loads of work?
View 3 Replies
Mar 30, 2008
I am trying to copy a table from a network database to a local database. I used DAO and could check if the network table existed using a function that tried to assign a TableDef object to the table in question. If there was no error then I assumed that the table existed and the function returned true...Or it would error out and return false.I could then proceed with the copy or not as the case may be.I am converting the code to ADO.net and need to know how to check for a table. [code]
View 1 Replies
Sep 20, 2011
Recently working in vb 2010 express. I'm using service-based database which is based on SQL Server. This database will be deployed at the server. Is it possible that multiple vb.net programs, which are installed in remote computers or client computers in the same network, connect to this database simultaneously? Does the service-based database support multiple connections?
View 1 Replies
Feb 2, 2009
I am noob to vb.net so be easy , i know in vb6 if you compile your project with p-code instead of native it can make a empty project 12kb, if i compile an blank project in .net it is 15kb with "Enable optimizations" enabled. is there anything else to make projects smaller?
View 3 Replies
May 5, 2009
how would i go about getting the of a fan of a computer that my program is running on in rps(revolutions per second) using vb.net?
View 4 Replies
Jul 22, 2009
I need to programmatically add a row to a MS Database.How is this done?
View 2 Replies
Feb 25, 2011
I don't actually know if I can use any XML file as a database that I can edit and make some changes to it using vb.net 2008 and save them. Because I'm working aboard a war ship and we have a central automatic system to control all the internal communication using standard telephones. to reprogram the extinctions we used to have a MS DOS program and it's so old and now it's totally lost and not found and after a long searching I have found a file that could maintain the extensions and reprogram the system but it's an XML file.
[Code]...
View 1 Replies
Jul 10, 2008
I'm using Visual Basic 2008 Express Edition. What I have is an Access database that will have several tables. What I want to do is connect to the database, enter the name of a table in a text box and query that table. The code that I have now is: [Code] I'm not sure how to modify this code so that tablename = whatever I type in the text box.
View 5 Replies
May 26, 2008
I am using SQL server managment express. I have 4 databases in it and got a bug on my computer which I could not get rid of. I saved these to disk and reinstalled windows, I reinstalled SQL server and I am now trying to add my 4 databases. Can any one help me with this, I can add a new database but not an existing.
View 2 Replies
Nov 16, 2009
I have working on a project to add details to a database. I'm having trouble with the connection string, the code is as follows:
Code:
Public Function AddContactToDatabase(ByVal sFirstName As String, ByVal sLastName As String, ByVal sAddress1 As String, ByVal sAddress2 As String, ByVal sAddress3 As String, ByVal sAddress4 As String, ByVal dDOB As Date, ByVal sPhone As String)
[Code]......
View 2 Replies
Jan 24, 2010
[Code]....
Thought I should probably say im using Windows 7 and the 2010 beta Visual studio
View 1 Replies
Feb 4, 2009
Using VB 2008 Express /Using SQL Server Express/Database name is "StopData"/Computer name is "LAPTOP"?Here's what I have.
Code:
Imports System.Data.SqlClient
Public Class frmMain
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[code].....
View 1 Replies
Jan 15, 2012
I have a database app that I wrote in VB6 a while back that uses Access as the backend. I have installed the app on Windows 7 pc's and all works fine....most of the time.On some pc's I see an issue where if I replace, rename, or even remove the DB, my app (b/c of something to do with Windows 7) still sees and reads the information from the old DB. It seems no matter what I do, I cannot "remove" the .mdb file from the system. As one can imagine, this is making it very hard to replace the outdated db with an updated version. I never experienced anything like this running the app in the XP environment.
View 3 Replies
May 18, 2011
below is the coding i want to ask :[code...]
this code is used for login by querying into the database....the logic is like this..it query accoding to the username text box and pass word text box...if there is indeed such rows in the table, then the bacadata.read, else something else happens...i have a few question :
1.is this the right way of login in by checking the row is available or not?
2.is there any enlightment and solution for the appropriate way to login system by using database other than the one teached by my lecturer?
View 2 Replies
Mar 2, 2011
I am trying to use the .net connector within my program. I have got add, delete and update working however cannot get search to work. What I would like the program to do is, you enter a value into a textbox and then press a button. The value in the textbox is searched and then the values in the database corresponding to that value are entered into the other text boxes. This is what I have so far:
Private Sub PrescriberSearch()
pre.SelectCommand = New MySqlCommand("SELECT Name FROM Prescriber WHERE Name =?Name like Name = ?Name")
[code].....
View 8 Replies
Mar 9, 2012
Well my problem is that I have a image stored in a database which is a OLE Object.
My Problem is that I am trying to view the database in Vb (windows form) but the image does not appear.
All I can see is a small red cross where the image should be.
I have tried both Datagrid view and Detail View.
View 2 Replies
