473,386 Members | 1,801 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

How to measure performance of a database, queries, execution etc

374 256MB
Hi all,

I understand if you have your back end located on a server and use things like mysql etc you are able to analyse a query from execution through to how it returns records to be able to see any bottlenecks and also improve the efficiency of your query design.

I am wondering if there is the same funtionality anywhere when creating queries within an access database with a back end that just comes out of your split database, not upsized to a dedicated server.

I am also wondering at the same time how do developers of access applications really analyse their programs to understand where they can make performance enhancements. I do a lot of reading around performance in general but these are more to do with specific tips you find such as loading subforms only when needed, turning off certain features that can slow down your database etc. However other than visually seeing a difference I can not really benchmark anything.

I think all of these questions stem from the fact I though I had messed up the design of my database in a recent update where the program was just SO SO slow to do anything. I have loaded it up since and it runs perfectly fine which would tell me this was to do with my actual computer and nott he design of my db. At the same time, for peace of mind I would like to understand any methods used to actually test your database set up (other than the performance analyser which just keeps saying "use fewer controls").

Sorry for the lengthy post.

Regards,

Chris
Sep 29 '10 #1
1 2470
munkee
374 256MB
Anyone have any input for this?
Oct 4 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: arabub | last post by:
I have an installation of Apache that apparently includes PHP (out of the box Redhat 9.0). If I make database calls to Postgresql, as what user is that call going to be made? The user that...
6
by: Mudge | last post by:
I'm writing PHP Web sites that are database driven with mysql. I'm looking for ways to measure the performance (speed) of my php code, so that I can find ways to write the fastest php code. Any...
1
by: valexena | last post by:
How can I improve performance of queries on tables containing all words in the dictionary starting with the letter ‘S’? -- Posted via http://dbforums.com
6
by: Andreas Lauffer | last post by:
I changed from Access97 to AccessXP and I have immense performance problems. Details: - Access XP MDB with Jet 4.0 ( no ADP-Project ) - Linked Tables to SQL-Server 2000 over ODBC I used...
1
by: cover | last post by:
Hi, Is there a site that anyone knows of, that shows creating a MySQL database from input through output is concerned? I'd LOVE to see a tutorial that included the interface for input, the usable...
0
by: mandara | last post by:
hi i was not able to write a programs such that it retrives the data from the database through sql queries and get the output in Excel using perl.when i write multiple Queries i need to get all...
2
by: jaffar.kazi | last post by:
Hi All. This might be the wrong group to post this query, since it is ADO.NET related, but I couldn't find any ADO.NET group. My problem is that I want to write some queries, which use temp...
6
by: DNB | last post by:
I would like to know what you guys think is the best way to access data: Asp.Net session vs. Database Queries. In our application we are using asp.net tree view to display hierarchical data and...
3
by: DNB | last post by:
I did post this message in C# group also... I would like to know what you guys think is the best way to access data: Asp.Net session vs. Database Queries. In our application we are using...
3
by: krishnaneeraja | last post by:
Hi, I am developing a HTML5 based application. I need to process two queries concurrently, one inside another. Pseudo code attached below: function main() { db.transaction( function...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
BarryA
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...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
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...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
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,...
0
jinu1996
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.