Advanced Visual Basic: Performance Tuning

NEWS OPTIONS
Current News
News Archive
Desktop News
By Company

RESOURCES
VB Forums
About VBWire
Link to VBWire
Links, Resources
Newsletter

SERVICES
Advertising
Add Your News
Be an Affiliate
Tech Jobs
Make Home Page

OTHER WIRES
ASPWire
PocketPCWire
Database Journal

internet.com

IT
Developer
Internet News
Small Business
Personal Technology
International

Search internet.com
Advertise
Corporate Info
Newsletters
Tech Jobs
E-mail Offers

internet.commerce

Be a Commerce Partner

Compare products, prices, and stores at Hardware Central!

We offer a free weekly newsletter covering all news related to Visual Basic! Subscribe today! Just enter your email address and press enter!

Question of the Week	Suggest!
How do you pay your bills? Online bill pay Snail mail Hand deliver Other

Tuesday, May 13, 2008 4:49 a.m. PT

Advanced Visual Basic	Home \| Comments \| VB News
How-To's \| Best of KB \| COM \| Threading \| Tuning \| Approved \| WinError

Performance Tuning & Optimizing VB

Books | General | OLE | Database

If you are serious about improving the performance of your application (highly recommended for commercial applications), get both of these books. You'll learn how to optimize everything... from a FOR loop to a relational database.

Visual Basic 4: Performance Tuning and Optimization
by Keith Brophy, Timothy Koets
Published by Sams Publishing
Publication date: December 1995

The how, what, why, when, and where of Visual Basic programming, this guide focuses on day-to-day optimization problems and their solutions. It introduces the reader to real-world performance tuning for every Visual Basic program. The CD contains information and source code to help readers fine tune Visual Basic for efficient database operation and the best possible Windows performance.

Optimizing Visual Basic 4
by W. Hitt
Published by Que
Publication date: November 1995

Learn to write code that can make programs runs as quickly and efficiently as possible--up to 300% faster. Learn to modify database code so that the programs access data information as much as five times faster. The CD contains several programs the user can run that will show speed/appearance differences between 20 or more examples of optimized and unoptimized code.

General Information

How to Optimize Size and Speed of Visual Basic Applications

This article describes how to optimize Visual Basic applications for size and speed.

Using For Each to Loop Through Arrays Is Not Recommended

You can also use the For Each statement with an array that is not a variant type, but the result is a substantial decrease in performance. This article shows by example how to use the For Each statement to loop through collections and demonstrates the decrease in performance that occurs when you use the For Each statement to loop through arrays.

OLE (COM) Information

Three Binding Types (Late, ID, Early) Possible in VB for Apps

Improve performance by declaring object references early instead of late. Here's how!

Tips to Improve Performance While Using OLE Servers

This article lists tips to keep in mind when instantiating an OLE server object, when calling a method, or when using a property of the object.

How to Optimize OLE Calls in Visual Basic 4.0

Because Visual Basic version 4.0 makes extensive use of OLE, the correct use of object references can be crucial to the performance of a Visual Basic application. This article suggests some optimizations that can be included at design time.

How to Optimize OLE Server Instance Usage by Using GetObject

This article gives a full explanation of the syntax of GetObject, adding to the information given in the "Programmer's Guide."

Database Information

How to Speed Up Data Access by Using BeginTrans & CommitTrans

You can speed up database operations by many times in a Microsoft Access database by using transactions. A transaction starts with a BeginTrans statement and ends with a CommitTrans or Rollback statement.

Performance Tuning Tips for VB and Access

This document contains performance tuning tips for Microsoft Visual Basic for Windows version 3.0 and Microsoft Access (TM) Relational Database Systems for Windows version 1.1. Some tips still hold true for VB4!

How to Optimize SQL Queries in Visual Basic 3.0 and 4.0

Visual Basic allows you to retrieve data from various databases by using Structured Query Language (SQL). These query operations can be made more efficient by implementing some of the suggestions in this article.

How to Optimize Queries in MS Access v2.0, 95, and 97

Visual Basic allows you to retrieve data from various databases by using Structured Query Language (SQL). These query operations can be made more efficient by implementing some of the suggestions in this article.

How to Avoid Common Database Programming Mistakes in VB

This article explains how to avoid some of the most common errors with Microsoft Visual Basic database programming. Use these tips to avoid unnecessary bottlenecks when executing queries on your databases.

Speeding Up Iterative Processes in Visual or Access Basic

To speed up iterative (looping) processes through large numbers of rows using Visual Basic for Applications (or Access Basic in version 2.0), declare all field references explicitly.

Back to top

Search:

Jupitermedia Corporation has two divisions: Jupiterimages and JupiterOnlineMedia

Jupitermedia Corporate Info

Legal Notices, Licensing, Reprints, & Permissions, Privacy Policy.

Advertise | Newsletters | Tech Jobs | Shopping | E-mail Offers

Whitepapers and eBooks
Microsoft Article: HyperV-The Killer Feature in WinServer �08 Avaya Article: How to Feed Data into the Avaya Event Processor Microsoft Article: Install What You Need with Win Server �08 HP eBook: Putting the Green into IT Whitepaper: HP Integrated Citrix XenServer for HP ProLiant Servers Intel Go Parallel Portal: Interview with C++ Guru Herb Sutter, Part 1 Intel Go Parallel Portal: Interview with C++ Guru Herb Sutter, Part 2--The Future of Concurrency		Avaya Article: Setting Up a SIP A/S Development Environment IBM Article: How Cool Is Your Data Center? Microsoft Article: Managing Virtual Machines with Microsoft System Center HP eBook: Storage Networking , Part 1 Microsoft Article: Solving Data Center Complexity with Microsoft System Center Configuration Manager 2007 MORE WHITEPAPERS, EBOOKS, AND ARTICLES

Webcasts
Intel Video: Are Multi-core Processors Here to Stay? On-Demand Webcast: Five Virtualization Trends to Watch HP Video: Page Cost Calculator Intel Video: APIs for Parallel Programming		HP Webcast: Storage Is Changing Fast - Be Ready or Be Left Behind Microsoft Silverlight Video: Creating Fading Controls with Expression Design and Expression Blend 2 MORE WEBCASTS, PODCASTS, AND VIDEOS

Downloads and eKits
Sun Download: Solaris 8 Migration Assistant Sybase Download: SQL Anywhere Developer Edition Red Gate Download: SQL Backup Pro and free DBA Best Practices eBook		Red Gate Download: SQL Compare Pro 6 Iron Speed Designer Application Generator MORE DOWNLOADS, EKITS, AND FREE TRIALS

Tutorials and Demos
How-to-Article: Preparing for Hyper-Threading Technology and Dual Core Technology eTouch PDF: Conquering the Tyranny of E-Mail and Word Processors IBM Article: Collaborating in the High-Performance Workplace HP Demo: StorageWorks EVA4400		Intel Featured Algorhythm: Intel Threading Building Blocks--The Pipeline Class Microsoft How-to Article: Get Going with Silverlight and Windows Live MORE TUTORIALS, DEMOS AND STEP-BY-STEP GUIDES