| Here at VB Profiler | |||
| Howdy! Welcome to my web site. | This site is dedicated to one thing - making VB code run faster. In full applications, ActiveX components and scripts (ASP, WSH), there are always ways of squeezing more horsepower from your hard won code. If you want to read more about why I put this site together, please feel free, but if you're in a hurry, I'll understand. | ||
When a VB String becomes a Noose! |
This original article shows the pitfalls of using VB's string concatenation mechanism, and presents a VB class which can potentially speed up your bottleneck code by a factor of 200 or more. | ||
| Use a Better Stopwatch for timing your code. |
If you want to do serious profiling, you have to use the QueryPerformanceCounter Win32 API function. I'll show you how. Also, download the easy-to-use, free PerfCt.bas code module for microsecond accuracy. | ||
| Elsewhere on the Internet | |||
This fun and interesting website, maintained by Donald Lessau, is sort of an ongoing contest, where participants try to outperform each other with who can write the fastest algorithm.
|
|||
| If you are currently using the Dir$ function for iterating files, then you are missing out on the speed and power that comes with the FindFirstFile and FindNextFile functions that are part of the kernel API. This snippet from VB-Zone shows an example of how to use this function. A sample project is also available for download. | |||
| In this article by Drew Seale, the notion that database access using ActiveX components is faster than direct access from ASP is put to rest. | |||
| This article by Suresh Kannan provides some handy tips for anyone using ADO or RDS as a means of data access. | |||
| This forum has several threads dedicated to improving VB code performance. | |||
| This article by David M. Williams duplicates some of the information from the Microsoft article, but also contains some new material. | |||
| Here are some tried and true tips on optimizing memory and getting better speed from your VB apps, compiled by Tuomas Salste, Aivosto Oy. Components/code for profiling your VB code are available on this web site. | |||
| This article by J. D. Meier give many helpful hints on how to increase performance on your ASP website. | |||
| This article by Charles Carroll explains why putting ADO objects into Application or Session scope variables will kill your ASP performance in the long run. Also, there are many performance related links on this page. Similar pages from Charles Carroll include Global.asa overkill, VB Component Threading details and No COM objects in Sessions | |||
| Hardcore VB author Bruce McKinney writes an addendum to the second edition. In this appendix, he takes a scrutinizing look at Collections, Dictionaries, Strings and the hidden VB pointers. His sarcastic wit and scathing assessment of Microsoft makes this article a real eye-opener. | |||
| This article is from Microsoft's Jet Database Programmer's Reference. It gives a few hints on optimizations specifically for this database. If you are not yet registered with MSDN Online, you may have to jump through a few hoops to get to this page. | |||
| This article is from VB2TheMax.com. It gives clear insight into how VB manages strings and memory and how you can improve performance. Noted author Francisco Balena wrote this very lucid piece for VBPJ. | |||
| This article is also from VB2TheMax.com. VB normally does not do short-circuit evaluation of the condition in If..Then statements. This article shows an unconventional way to effect short-circuit your conditionals, with the net effect of improving performance. | |||
| This article by Mack Male can be found at vbsquare.com, an excellent source for tips and technical articles. | |||
| Lots of great tips on VB performance tuning. Note: this is not vbhelper.com, which is a placeholder web site. | |||
There are thousands of VB sites on the Internet, so it would be pointless for me to maintain my own links page. Instead, I point you to some of the premiere VB sites that are dedicated primarily to linking other more specific VB sites.
More to come...
|
|||