How to create quantitative benchmark model for database optimization ?

Chaminda Anuradha Jayakody @Chaminda-Jayakody

16 March 2017 1 6K Report

-Data insertion

-Data Retrieval

-execution

-indexing

Aspen Olmsted

There are many approaches to take to measure the performance before and after optimization:

- Tools such as MySQL Workbench record the time to execute a query

- Tools such as JMeter allow you to script to JDBC and record execution time

Badges
Science topic

Similar topics
Books

More Chaminda Anuradha Jayakody's questions See All

How does transportation real-time tracking influence delivery?

This is to investigate the effect of Real-time tracking of transportation on goods delivery in New Zealand context. Further need to understand how the transportation characteristics like...

07 May 2024 2,721 0 View

What are the barriers and facilitators to implementing effactive strategies to improving oral healthcare access in specific regional sectors ?

Please give me some scientific evidence from the perspective of implementatiion science

10 July 2023 2,015 1 View

Can I merge my previous account which I created with my previous institution?

Can I merge my previous account, which I created with my previous institution? But I o not have access to my previous email address.

26 March 2023 9,205 0 View

Why RO membrane modules of 10 TPD brackish water RO plant which is installed in Puttalam clogging frequently ?

Sir, This 10 TPD brackish water RO plant is installed in Puttalam District and all the filter modules and RO membranes are replaced. However, it was observed that the RO membranes are frequently...

03 January 2022 4,936 3 View

How to improve efficiency by bundling up multiple REST calls within a single REST call?

-Exporting a single API require multiple resources(API thumbnail, definitions, documentations) to be retrieve from the back-end - This require number of REST calls -This will effect the true...

06 May 2017 643 0 View

Is village banking system practically useful approach to rural development process of the developing countries ?

'village banking system has been developed by Muhammad Yunus with considering rural context of Bangladesh. Is it useful to the other developing countries to achieve rural development? What are the...

27 January 2017 2,235 11 View

Could you please help me to collect some information about 'Ecogovernmentality"?

I want to collect some information about 'Ecogovernmentality' . Please send me some information about this concept

27 January 2017 3,000 2 View

Is 'Malthus demographic theory'still valuable to understand and analyze natural resource conflicts of the world?

I am doing some research work regarding natural resource conflicts, especially in the developing context. so I am looking for some suitable theories that can be use to understand and examine this...

26 January 2017 1,254 5 View

How about the "Challenges of Biopiracy" in the developing context ?

Protecting the right of the local community/country to use their own genetic resources available in a particular area is an important element of environmental and biodiversity conservation....

25 January 2017 5,791 4 View

What are the "theories" that have associated with "Spiritual Ecology"

for my research work I have to find out theoretical rationality to develop the concept of 'Spiritual Ecology'. Could you please help me to find out better sources for that?

24 January 2017 5,865 5 View

How to learn more about SPSS and its Application?

I would like to learn more about SPSS and Its application especially in regards to data analysis. Please suggest me how I can learn more about it. Thank you so much.

11 August 2024 9,101 4 View

Handling Missing Data and Building a Predictive Model with Incomplete Information ?

I am developing a predictive model for a water supply network that involves 20 influencing points. However, I only have historical data for 10 out of these 20 points. I would like to know how to...

10 August 2024 4,005 2 View

Has anyone applied Python in the field of textile engineering for data analysis, automation, or smart textiles?

I'm currently exploring the application of Python in textile engineering, specifically in areas like data analysis, process automation, and the development of smart textiles. I'm interested in...

10 August 2024 7,429 2 View

Is Galaxy.org good to use for research for analyzing data and for publication?

Hello all, I wanted to know, can I use galaxy (USA, Europe or Australia) platform for analyzing the shotgun data, and can it be used for publication purpose as well? Thanks :)

06 August 2024 6,610 4 View

Do experts have journals in the field of artificial intelligence and big data that are not indexed by SCI or EI?

05 August 2024 8,836 2 View

What are possible strategies can be used to analyze data under sequential explanatory mixed method approach?

Better ways to analyze the qualitative and quantitative data in a sequential explanatory mixed method approaches

04 August 2024 2,703 6 View

What should Berlin do as a city to become as impactful as London and Paris in World Football?

Please go through my Abstract. I can also share a proposed Thesis Outline.

04 August 2024 2,077 0 View

Identify the eight key processes of excellent supply chain management and discuss how each of these processes impacts the end customer?

Read the journal article by Douglas M. Lambert, “The Eight Essential Supply Chain Management Processes,” Supply Chain Management Review, Vol. 8, No. 6 (2004), pp. 18-26

04 August 2024 9,919 4 View

How can I interpret the data without the need of solving it manually?

How can I interpret the data gathered without solving?

03 August 2024 9,054 3 View

Broca’s area must be intact for the learning of new movement sequences?

When the eyes of a person are damaged this causes complete blindness. Likewise, when Wernicke’s and Broca’s areas of neocortex are damaged this causes complete aphasia, losing the ability to...

01 August 2024 6,744 2 View