Make MYSQL PHP Database connected with apps Faster based on report
- or -
Post a project like this2213
$$$
- Posted:
- Proposals: 9
- Remote
- #1924331
- Awarded
2109291726048925637150849415373551594646177642918891861975120
Description
Experience Level: Expert
Please see issues from report on speed of database and what needs to be done.
Application Issues:
1. Database query optimization.
We have checked and our app’s main key part is database and API so
we have checked API.
Let’s take one example of profile controller. In profile controller
many db queries are executing for collect data and show but query is
written for get all the data and use only few field just 2 or 3 so we
have define only required field and fetch only that db and that query
execution is take more time. We need to use “Select Clause” in every
API. Please check below API.
/app/Http/Controllers/Candidates/V1/ProfileController.php
We have to set “LIMIT” statement in query if there is required for
single record from database
2. Reduce API call for compliance status.
We have checked app and debug for where and which API is called
for get data.
So on console there is compliance api which is called on every few
minute for check compliance status.
So we have to stop that API call and only set on any user click on
home from slide menu.
3. Minify all server files.
For now, all there is many images, CSS &JS which is used and
included in the app.
So we will compress all the CSS & JS and then we will include that
files so it’s occupies less memory in the app and quick compiling that
files.
4. Remove unnecessary & commented code from server's & app's files.
We have checked there is lots of code is there in server & app files are
not used in the app.
So we will remove that all the comment in both side server & app file
so file size will reduce and its increase little bit in app speed.
5. Clear local application cache on sign-out.
User install the app and few days after app size is increasing because
there is many data is storing in local as cache and it’s effecting on
app size.
Many people’s are clearing cache manually so we will set code for
clearing cache when user wills logout from account.
6. Start-up takes too much time need to be fixed server connection and startup
code optimization.
In app there is one plug-in “Native Audio”. This plug-in is actually
installed but ionic is didn’t find so at the start-up of app the
framework taking the time for searching that plug-in.
So we will check that issue and fix so it’s won’t take time at the app
start-up.
7. Need to check all the plug-in and remove if it unnecessary.
There are many plug-in installed in ionic and we don’t know which is
used in current functionality so we need to check whole app with
plug-in If there is any unnecessary installed.
So we need to remove from project and test project and app size will
reduce
Must be able to complete quickly
Application Issues:
1. Database query optimization.
We have checked and our app’s main key part is database and API so
we have checked API.
Let’s take one example of profile controller. In profile controller
many db queries are executing for collect data and show but query is
written for get all the data and use only few field just 2 or 3 so we
have define only required field and fetch only that db and that query
execution is take more time. We need to use “Select Clause” in every
API. Please check below API.
/app/Http/Controllers/Candidates/V1/ProfileController.php
We have to set “LIMIT” statement in query if there is required for
single record from database
2. Reduce API call for compliance status.
We have checked app and debug for where and which API is called
for get data.
So on console there is compliance api which is called on every few
minute for check compliance status.
So we have to stop that API call and only set on any user click on
home from slide menu.
3. Minify all server files.
For now, all there is many images, CSS &JS which is used and
included in the app.
So we will compress all the CSS & JS and then we will include that
files so it’s occupies less memory in the app and quick compiling that
files.
4. Remove unnecessary & commented code from server's & app's files.
We have checked there is lots of code is there in server & app files are
not used in the app.
So we will remove that all the comment in both side server & app file
so file size will reduce and its increase little bit in app speed.
5. Clear local application cache on sign-out.
User install the app and few days after app size is increasing because
there is many data is storing in local as cache and it’s effecting on
app size.
Many people’s are clearing cache manually so we will set code for
clearing cache when user wills logout from account.
6. Start-up takes too much time need to be fixed server connection and startup
code optimization.
In app there is one plug-in “Native Audio”. This plug-in is actually
installed but ionic is didn’t find so at the start-up of app the
framework taking the time for searching that plug-in.
So we will check that issue and fix so it’s won’t take time at the app
start-up.
7. Need to check all the plug-in and remove if it unnecessary.
There are many plug-in installed in ionic and we don’t know which is
used in current functionality so we need to check whole app with
plug-in If there is any unnecessary installed.
So we need to remove from project and test project and app size will
reduce
Must be able to complete quickly
William J.
97% (27)Projects Completed
15
Freelancers worked with
14
Projects awarded
35%
Last project
12 Mar 2021
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies