Optimization technique - Microsoft Access / VBA

Sorry for my bad english

What is the optimization technique used by Access dbms?

Thanks

Nov 13 '05 #1

1477

I'm not sure that anyone knows what you meant by "optimization". A little
more description of what you mean, are try to accomplish, something that
doesn't work as you expect, would be helpful.

Some general suggestions:
1. Repair and compact (under the Tools-Database Utilities menu) should be
run periodically to remove blank space/deleted objects and reindex the
tables.

2. Index (at a minimum) on the most common search/filter fields to greatly
speedup queries.

3. Each user on a network should have their own local front-end mdb linked
to a common server mdb that has the data tables.

4. Run the Analyzer (also under Tools menu) to /get tips on your database
structure.

-Ed

"Ruggiero" <ru***********@hotmail.com> wrote in message
news:a0**************************@posting.google.c om...

Sorry for my bad english

What is the optimization technique used by Access dbms?

Thanks

Nov 13 '05 #2

Tom van Stiphout

On 9 Feb 2005 03:05:03 -0800, ru***********@hotmail.com (Ruggiero)
wrote:

Are you referring to Rushmore?
-Tom.

Sorry for my bad english

What is the optimization technique used by Access dbms?

Thanks

Nov 13 '05 #3

Similar topics

Over optimization

by: Bonj | last post by:

When performance benchmark testing one of my own functions against the equivalent runtime function, I found that with /Ox on it optimized away its own function so that it didn't call it *at all*...

C / C++

Optimization technique

by: Ruggiero | last post by:

Sorry for my bad english What is the optimization technique used by SqlServer dbms? Thanks

Microsoft SQL Server

String manipulation, optimize

by: Rune | last post by:

Is it best to use double quotes and let PHP expand variables inside strings, or is it faster to do the string manipulation yourself manually? Which is quicker? 1) $insert = 'To Be';...

PHP

C portability is a myth

by: roman ziak | last post by:

I just read couple articles on this group and it keeps amazing me how the portability is used as strong argument for language cleanliness. In my opinion, porting the program (so you just take the...

C / C++

A Sort Optimization Technique: decorate-sort-dedecorate

by: xahlee | last post by:

Last year, i've posted a tutorial and commentary about Python and Perl's sort function. (http://xahlee.org/perl-python/sort_list.html) In that article, i discussed a technique known among...

Python

open bank policy optimization

by: alexquisi | last post by:

Hi, I am newbie in optimization techniques and I need a little of help. I want to take adventage of the open bank and open row policy available in the processor (it can keep 4 banks open per...

C / C++

Appropriate Query Optimization Technique(s) Sought for the FollowingCase

by: Don Li | last post by:

Hi, Env: MS SQL Server 2000 DB Info (sorry no DDL nor sample data): tblA has 147249 rows -- clustered index on pk (one key of datatype(int)) and has two clumns, both are being used in joins;...

Microsoft SQL Server

gcc power optimization

by: AJ | last post by:

Hi, I am trying to optimize gcc for power consumption. Technique I am using is rescheduling instruction based on hamming distance between two consecutive instructions. Now I want to create a new...

C / C++

Zero Optimization and Sign Optimization???

by: Ravikiran | last post by:

Hi Friends, I wanted know about whatt is ment by zero optimization and sign optimization and its differences.... Thank you...

C / C++

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice