A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Free for All: help me speed up my Access Database



 
 
Thread Tools Display Modes
  #21  
Old January 10th, 2007, 08:28 PM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access
Niniel
external usenet poster
 
Posts: 582
Default Free for All: help me speed up my Access Database

Oh, interesting.
So you are better off with a pair of 10k rpm hds with a ton of cache. Or/and
a TB of RAM and a RAM drive.
At which point more processing muscle may become a factor again.

Ads
  #22  
Old January 10th, 2007, 08:28 PM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access
Klatuu
external usenet poster
 
Posts: 7,074
Default Free for All: help me speed up my Access Database

Congradulations, you have just been designated as an MVT!
(Most Valued Trekkie)
--
Dave Hargis, Microsoft Access MVP


"Niniel" wrote:

Bah, that's too easy... NCC 1701 A-E.

  #23  
Old January 10th, 2007, 08:43 PM posted to microsoft.public.access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulescoding,microsoft.public.access.modulesdaovba
'69 Camaro
external usenet poster
 
Posts: 1,049
Default Free for All: help me speed up my Access Database

And it's even faster if you delete all the data: that way, you don't
even need to open the database to know the answer it will give you.


Don't forget to compact it afterwards to squeeze all the excess air out so
you get the best aerodynamics for that hyperspeed.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"John Nurick" wrote in message
...
On Wed, 10 Jan 2007 12:37:10 -0600, "Anthony"
wrote:

What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?

Single user, not split, on a RAM drive on a superfast machine.

And it's even faster if you delete all the data: that way, you don't
even need to open the database to know the answer it will give you.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.



  #24  
Old January 10th, 2007, 08:46 PM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access
John Spencer
external usenet poster
 
Posts: 7,815
Default Free for All: help me speed up my Access Database

Open up a table in design view and Select View: Properties from the menu.
There is code that will step through all the tables and set the property to
None

'Source: MS Knowledge Base #275085 (See the following URL)
http://support.microsoft.com/Default.aspx?id=275085


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Niniel" wrote in message
...
That was interesting, John, thank you.
Could you please tell me where I can find the "sub datasheet name
property"?



  #25  
Old January 10th, 2007, 08:58 PM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access
Niniel
external usenet poster
 
Posts: 582
Default Free for All: help me speed up my Access Database

All right, thank you very much.

  #26  
Old January 10th, 2007, 09:33 PM posted to microsoft.public.access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulescoding,microsoft.public.access.modulesdaovba
Anthony
external usenet poster
 
Posts: 176
Default Free for All: help me speed up my Access Database

damn!

"'69 Camaro" AM wrote in
message ...
And it's even faster if you delete all the data: that way, you don't
even need to open the database to know the answer it will give you.


Don't forget to compact it afterwards to squeeze all the excess air out so
you get the best aerodynamics for that hyperspeed.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"John Nurick" wrote in message
...
On Wed, 10 Jan 2007 12:37:10 -0600, "Anthony"
wrote:

What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?

Single user, not split, on a RAM drive on a superfast machine.

And it's even faster if you delete all the data: that way, you don't
even need to open the database to know the answer it will give you.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.





  #27  
Old January 10th, 2007, 09:36 PM posted to microsoft.public.access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulescoding,microsoft.public.access.modulesdaovba
Rick
external usenet poster
 
Posts: 2
Default Free for All: help me speed up my Access Database

Direct answer. Delete the records.


"Anthony" wrote in message
...
What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?



  #28  
Old January 10th, 2007, 09:36 PM posted to microsoft.public.access,microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba
external usenet poster
 
Posts: n/a
Default Free for All: help me speed up my Access Database

Use a SQL Server backend.

No, than does not make my application run faster.

Perhaps you mean 'rebuild your application entirely, using
client-server principles'?

No, that does not make my application run faster.

One of the regular posters here has a relevant comparison:

A sports car is faster than a bus. But a bus can get 30 people
from A to B faster than the sports car.

The bus is SQL Server. It is not faster. Jet is faster.
But SQL Server can do more transactions on a larger
database in the same time.

One of the reasons Jet is faster is that it is a distributed
database engine. Most of the processing takes place on
your workstation. You don't have to share your processor
and memory with all the other people doing transactions.

One of the reasons SQL Server can do more transactions
on a larger database in the same time is that the Jet records
remain locked for longer. Jet does automatic retries when
there is a locking conflict, but it limits the throughput of the
system.

(david)


"ManningFan" wrote in message
ups.com...
Use a SQL Server backend. And index your tables properly.

Anthony wrote:
What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?




  #29  
Old January 10th, 2007, 09:45 PM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access
external usenet poster
 
Posts: n/a
Default Free for All: help me speed up my Access Database

I don't believe Access can take advantage of multi-threading.

Jet is multi-threaded. The default number of threads is 3. This
causes a problem with IIS. IIS tries to create multiple database
threads: inside the thread creation code, Jet tries to create
multiple threads. Windows thread creation code is not re-entrant,
and it crashes. Solutions are to restrict IIS to a single database
thread, use a special database method that I don't understand, or
(my idea) change the registry setting so that Jet only uses one thread.

Also, Windows can take advantage of multi-threading, and Jet uses
Windows as part of the database engine. By default, applications
run on one processor, and the OS runs on the other, so all of your
SQL would be on one processor, and all your file operations would
be on the other. Right?

(david)

"Douglas J. Steele" wrote in message
...
I don't believe Access can take advantage of multi-threading.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Niniel" wrote in message
...
Turn it into a multi-threaded application and run it on a

multi-processor
system, that should speed things up.
For true lightspeed-like speed you'll probably have to build yourself a
quantum computer.

"Anthony" wrote:

What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?







  #30  
Old January 10th, 2007, 10:41 PM posted to microsoft.public.access.forms,microsoft.public.access.formscoding,microsoft.public.access.modulesdaovba,microsoft.public.access
Tom Wickerath
external usenet poster
 
Posts: 3,914
Default Free for All: help me speed up my Access Database

To add to John's comments, perhaps you will find this document helpful:

Implementing a Successful Multiuser Access/JET Application
http://www.access.qbuilt.com/html/mu...lications.html

Several of the ideas included are equally applicable for a single-user
database.


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/ex...tributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

"John Spencer" wrote:

Quote from Tony Toews
The three most common performance problems in Access 2000 a
- LDB locking which a persistent recordset connection fixes
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off
(Tools: Options: General Uncheck all name AutoCorrect features)
Other reasons are
- New format of Access 2000 MDB
- Place backend MDB on the root of the network share rather than several
folders down
- Shorten the name of the backend MDB
- Miscellaneous Performance Suggestions
End quote

Check out the following URLs for a more complete discussion.

http://www.granite.ab.ca/access/performancefaq.htm

http://support.microsoft.com/?id=209126

Also
How to speed up slow queries
http://support.microsoft.com/kb/209126/en-us
Entitled: Information about query performance in an Access database

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Anthony" wrote in message
...
What does EVERYONE recommend I do to make my database run as close to
lightning speed as possible?




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:16 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 OfficeFrustration.
The comments are property of their posters.