.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

Best practice??

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :
 

Hi

We have a c# based application which uses a sqlce 3.5 database, as the amount of data this requires has increased we appear to be getting "out of memory" errors!

I have made some observations and would like somebody to confirm them if possible: -

  1. If opening the database at the beginning of the application and keeping it open during lots of reads/writes/deletes then the database size grows similar to an Access database some sort of work area that's only released upon closing the connection.
  2. In an attempt to prevent the above we modified the code to close the db connection every tenth operation and then re-open the connection when next needed.  Now this appears to have created another problem whereby the system now crashes with "out of memory" errors even though there is available memory on the device at this point.

So to conclude what exactly is the way forward/best practice with regards making our application as robust as possible in relation to coding?

Thanks in advance

Andy




View Complete Post


More Related Resource Links

Usability in Practice: The Decade of Convergence

  

As devices converge, user experience design needs to change, too.

Dr. Charles B. Kreitzberg

MSDN Magazine April 2010


Patterns in Practice: Internal Domain Specific Languages

  

Jeremy Miller explains how internal Domain Specific Languages can help you craft code that is easier to read and write. His bag of tricks to improve your programming includes extension methods, fluent interfaces, object extensions and use of the semantic model.

Jeremy Miller

MSDN Magazine January 2010


Usability in Practice: More Than Skin Deep

  

While style and slick visuals are important in Web site design, they shouldn't detract from a site's usability and functionality. Here are some hands-on tips for look and feel, readability, discovery of affordances, and more, with plenty of examples of good and bad design.

Ambrose Little, Charles B. Kreitzberg

MSDN Magazine December 2009


Usability in Practice: Search Is Key to Findability

  

In this column, Ambrose Little and Charlie Kreitzberg discuss best practices, design patterns, and other considerations related to implementing a search feature.

Ambrose Little, Charles B. Kreitzberg

MSDN Magazine November 2009


Patterns in Practice: Functional Programming for Everyday .NET Developers

  

This article examines how the new support for functional programming techniques in .NET 3.5 can developers make code more declarative, reduce errors in code, and write fewer lines of code for many common tasks.

Jeremy Miller

MSDN Magazine October 2009


Usability in Practice: Getting Inside Your Users' Heads

  

This article explores techniques developers can use to gather information about and incorporate their users' mental models in their software designs.

Ambrose Little, Dr. Charles B. Kreitzberg

MSDN Magazine October 2009


Usability in Practice: The Tao of Screen Design

  

This article describes methods for designing screens in a user interface and the technology frameworks that support screen design.

Ambrose Little, Charles B. Kreitzberg

MSDN Magazine September 2009


Patterns in Practice: Incremental Delivery Through Continuous Design

  

The end goal of software projects is to deliver value to the customer. Software design is a major factor in how successfully a team can deliver that value. The best designs are a product of continuous design rather than the result of an effort that tries to get the entire design right up front. This approach lets you strive to apply lessons learned from the project to continuously improve the design, instead of becoming locked into an erroneous design developed too early in the project.

Jeremy Miller

MSDN Magazine August 2009


Usability in Practice: Usability Testing

  

This month's column describes the benefits and methodologies of usability testing.

Dr. Charles B. Kreitzberg and Ambrose Little

MSDN Magazine July 2009


Usability in Practice: Agile Ux Development

  

This month the authors show you how to treat the user experience as an essential dimension of the development process while retaining the advantages of Agile.

Dr. Charles B. Kreitzberg and Ambrose Little

MSDN Magazine June 2009


Patterns in Practice: The Unit Of Work Pattern And Persistence Ignorance

  

Jeremy Miller continues his discussion of persistence patterns by reviewing the Unit of Work design pattern and examining the issues around persistence ignorance.

Jeremy Miller

MSDN Magazine June 2009


Usability in Practice: Useful, Usable and Desirable: Usability as a Core Development Competence

  

In this month's installment, learn how to achieve the most important outcome of all UI design: ensuring that your software is useful, useable, and desirable.

Dr. Charles B. Kreitzberg and Ambrose Little

MSDN Magazine May 2009


Patterns in Practice: Persistence Patterns

  

Here we examine data persistence patterns to help you determine which best suits your needs. We look at a number of patterns, including the Active Record, the Data Mapper, the Repository, the Identity Map, the Lazy Loading, and the Virtual Proxy.

Jeremy Miller

MSDN Magazine April 2009


Usability in Practice: The Power of Personas

  

A persona is a description of a fictional person representing an amalgamation of traits found in a segment of your users. Emplolying personas arms you with a powerful foundation on which to base design decisions.

Dr. Charles B. Kreitzberg and Ambrose Little

MSDN Magazine April 2009


Usability in Practice: Strategies for Designing Application Navigation

  

Good navigation makes for happy users, and happy users are good for your business. See what makes users happy this month.

Dr. Charles B. Kreitzberg and Ambrose Little

MSDN Magazine March 2009


Best Practice: An Introduction To Domain-Driven Design

  

We give you a gentle introduction to designing and evolving rich domain models as part of integrating Domain-Driven Design (DDD) into your coding efforts.

David Laribee

MSDN Magazine February 2009


Patterns in Practice: Convention Over Configuration

  

We look at some techniques you can adopt to reduce the amount of housekeeping code you write so you can focus on the essence of the application.

Jeremy Miller

MSDN Magazine February 2009


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend