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. |
|
|
Thread Tools | Display Modes |
#21
|
|||
|
|||
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. |
#22
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
Free for All: help me speed up my Access Database
All right, thank you very much.
|
#26
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|