logo
g Text Version
Beauty & Self
Books & Music
Career
Computers
Education
Family
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
Money
News & Politics
Relationships
Religion & Spirituality
Sports
Travel & Culture
TV & Movies

dailyclick
Bored? Games!
Nutrition
Postcards
Take a Quiz
Rate My Photo

new
Creativity
Family Travel
Southwest USA
Irish Culture
Home Finance
Comedy Movies
Romance Novels


dailyclick
All times in EST

Clairvoyance: 08:00 PM

Full Schedule
g
g ASP Site

BellaOnline's ASP Editor

g

MDAC and Database Connections

Guest Author - Lisa Shea

Every time you make a connection to your database, you are burning 7mb of memory. Learn to manage this well, to keep your system running smoothly.

First, make sure you go through the various articles on this site to code well. Close any connections you open. Open as few connections as possible, getting content in bulk instead of going back and requesting little pieces one by one. Name your tables and field names something meaningful but short so that the traffic back and forth is as small as possible.

Still, every time you open a connection, by default the MDAC - Microsoft Data Access Components - sets aside 7mb of memory for that connection. If you happen to have 30 concurrent users, that's a fair chunk of memory being set aside and probably not needed at all.

Use Start - Run and type in REGEDIT to edit your registry. Always back up your registry before modifying it, and do these changes at quiet times of the night! Look for

HKEY_CLASSES_ROOT
CLSID
{c8b522cb-5cf3-11ce-ade5-00aa0044773d}

In here, make a new key and call it

Flags

In the Flags key, make a new Dword. Name it

MaxBlock

set its value to 000040000 in Hex.

Now exit and reboot!
This site needs an editor - click to learn more!

Add MDAC+and+Database+Connections to Twitter Add MDAC+and+Database+Connections to Facebook Add MDAC+and+Database+Connections to MySpace Add MDAC+and+Database+Connections to Del.icio.us Digg MDAC+and+Database+Connections Add MDAC+and+Database+Connections to Yahoo My Web Add MDAC+and+Database+Connections to Google Bookmarks Add MDAC+and+Database+Connections to Stumbleupon Add MDAC+and+Database+Connections to Reddit




RSS | Related Articles | Editor's Picks Articles | Top Ten Articles | Previous Features | Site Map


For FREE email updates, subscribe to the ASP Newsletter


Past Issues


print
Printer Friendly
bookmark
Bookmark
tell friend
Tell a Friend
forum
Forum
email
Email Editor


Content copyright © 2014 by Lisa Shea. All rights reserved.
This content was written by Lisa Shea. If you wish to use this content in any manner, you need written permission. Contact BellaOnline Administration for details.

g


g features
Best uses for RSS

RSS and its future.

Force Download Dialog box with ASP

Archives | Site Map

forum
Forum
email
Contact

Past Issues
memberscenter


vote
Poetry
Daily
Weekly
Monthly
Less than Monthly



BellaOnline on Facebook
g


| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2014 Minerva WebWorks LLC. All rights reserved.


BellaOnline Editor