If you have a slow Magento store and you want to speed up & optimize its performance then these tricks can help you.
In this project you have to do below tasks: 1:ER Diagram 2:Normalization 3:Create tables in oracle and insert some data 4:Answer some sql queries This is not a tough project if you have a knowledge of database [login to view URL] detail will be shared in a chat box. Moreover,The budget of this project is limited so bid accordingly. Thanks
I am looking to have my Wordpress Site Optimized. There might be some issues with some queries or the database structure that is causing a high TTFB. Here are the optimizations that Google has suggested. 1 - Avoid enormous network payloads Total size was 9,133 KB 2 - Avoid an excessive DOM size - 4,156 nodes 3 - Minimize main-thread work - 16.7 s
I have a Visual studio Form written in c++. This is for a business and i need my sales data put into text boxes on my Visual studio form. The database is already integrated and being used in the project. Thanks Aaron
- The solution must include a good database schema with all the SQL queries to create it. - The software must have a PHP config interface where the admin can establish the time between updates sorting it in 3 kind of events: past events, live events and future events. For each type the admin must be able to schedule the frequency to update (ex: update
Looking for a drawing of a useful interface to allow users to perform adhoc queries of a database They should be able to select fields, build a query, make decisions on aggregate functions on fields and potentially create field aliases for nice data output. They should be able to do drag and drop as well as potentially direct query entry.. We are looking
DATABASE DEVELOPMENT We are a small business in Sweden offering a bed linen rental subscription service for private homes. In order to keep track of our stock and deliveries we have implemented RFID chips into our products. Upon each order every product that leaves our warehouse is scanned and the RFID number is connected to the customer. Once the
identify single fact schema, logical schema. Populate sample date is mySQL. Provide OLAP queries
Job Description Adgeco is currently in search of a creative and...execution – Ability to express ideas and issues clearly and effectively – Mobile Coding and Media Queries – Wide understanding of CMS, building and managing content in CMS environments – Plugin Management – Email/Newsletter Development – Database management and backups
...list of database project ideas. You must choose one of them to design and implement. B. You can work on this project as a group (maximum 3 students) or individually. You have to send the names of group members to your instructor by the end of week 7. C. This project worth 10 marks, will be distributed as in the following: a. Design the database, following
Need a simple www interface which allows me to search fields in our database or insert. Blank site with this example funtionality: - field called "users" which will search for username in users table and print info togetehr with bought goods from another table - field called "transactions" for search transaction accross one table - site "tickets" where
Show evidence of understanding... understanding of various Business Intelligence concepts, through the design of data marts and implementation of OLAP queries. Implementation is performed in R/MySQL environment, while students need to perform OLAP queries and investigate the use of R for performing multidimensional analysis over Big Data Sets.
We are a small manufacturing shop. We are looking for a mid-to high-level of expertise in using the E2 Shoptech system (which is essentially an Access DB) to perform analyze and make data corrections, perform data entry, and produce reports. Expertise in Crystal Reports would be ideal to create new reporting from the system.
Create a user interface with set of questionnaire. Collect the answers and store the collected data on to the tables in the database. Print a thank you message on a web page once the user submits all the information Create SQL queries to retrieve the information from the data base and print it on a separate web page.
...GraphQL Yoga Prisma I'd like to see your portfolio and you'd have main project tasks such as: CSV upload to a database using a models server Must be able to incorporate mapbox Using React-Apollo for performing GraphQL mutation, fetching queries, caching (taking care of cache invalidation), managing local state, error, and loading UI states I look forward
I have a large WordPress site and something has gone wrong with the database and it keeps spiking the load on the server and crashing the site. It appears there are there are a number of queries waiting for processing. I need a Mysql engineer to investigate the site crashing and see if we can determine what in the DB is causing the issues. PROJECT
...theme we chose. We will want it to display differently on mobile vs desktop (not just responsive but different layout) 3) Integrate our local IDX feed, help set up the database and queries needed to display data on the website. Here is some information on the RETS [login to view URL] 4) Install and connect a few plugins to our
I need a php programmer to create a php script file that performs 10 essential queries on the sql database tables that have information. The results should always be based on 2 specific reference points, which will be user_id and page_id. Please bid with actual cost. this should be able to be inserted into a header file as require once, to be referred
...service that receives standard SMTP queries from external mail providers. It ideally has the following features; - the facility to execute a logic app (such as Lamda or Azure Functions) to determine if to catch and hold the e-mail for later release - the facility to store held e-mails in an enterprise database system, like Microsoft SQL server with
...because the purpose is interact with Moodle database, it is required to follow specific formatting Moodle requires in order to show the appropriate results from my query. Please check the attached php file contaning the whole code. You need previous experience working with Moodle plugins creation or SQL queries in Moodle in order to achieve what is required
I have a proble...a fix to the following problem: Basically, the plugin/widget is pulling some taxonomies and fields from the database, and because Redis caching is enabled on the website, these queries are being cached. I need to either exclude these queries being cached, or I need to purge a the Redis cache everytime this widget is evoked. Thanks!
Hi I'm looking for a skilled python expert who can commit and call everyday. The goal would be create queries and scripts for deployment of features in the sandbox and production database (MongoDB). The data extraction would need to be done from AWS S3, Data warehouse including obtaining data from multiple external APIs. If you can't commit and call
...or similar sites. The site will be developed in ASP.Net with MS SQL Server Database, though the database is already live, so no need for designing the same. Most pages will be like About Us, Our Services, Gallery, On-line Tracking etc. You'll be provided with all MS SQL queries to be run, just need to do the formatting part and there will be 1 (one) page
Issac G. "You will be getting the look of your old interface but with the functions that I give everyone with includes queries (you can build your own), exporting to xls and csv, managing user (of the back end) and the database table layouts. $280 is due when I post the layout without code with the balance once it goes live. You should be live no later
...like to migrate an Access 2007 Database so that it can be accessed by multiple people from multiple sites. (Mostly 2 admin staff). The database is a CRM and job scheduling tool used for a small business of 5 employees. The Database currently integrates with Outlook for calendar functions (it books jobs from the database directly into an Outlook calendar)
I have a Lenovo Server with Windows server 2016 R2 as a domain con...Lenovo Server with Windows server 2016 R2 as a domain controller, we have a CRM working with SQL Express 2017 and we want to have a web portal, where we can make queries to the database and see all the info related to the entry in there. I would like to have a preview of the portal.
...infrastructure (PHP5 to PHP7, MySQL to latest version, etc) - Replace Apache with Nginx - Identify and optimize any slow queries in our current theme - help us setup CDN - help us setup heavy caching (to files instead of database), or maybe even reverse proxy Looking for a long term relationship. This project won't have a lot of heavy lifting in one
...Action Cable. 5. Multiple currency support as in fiverr. 6. Skinny Models, Skinny Controllers, Fat Services. 7. Optimized queries and clean code. 8. Deployment not needed. 9. Elastic or solr search for text search. 10. Database: Postgres 11. Caching: Redis 12. Sidekiq for sending emails and other background jobs. Special Requirement: a. Buyers
These are the queries I want you to write. Refer to the attachment for more info. Find all the pairs of musicians (give names) who share an address. Find the songs that are not performed by any musician. Find the musicians (names) who played all the songs written by 'John' (musician author name = 'John'). Find the musicians who perform a song they
...are updating/fixing an existing Access database and need the tables, queries, etc to be renamed/checked and all instances of old names updated throughout code and back-end. Once updated will need to be tested to ensure full functionality. We also require a report menu form (currently 5 different forms/queries) to be combined into one form selecting
Need a developer with skills in Python development. The goal would be create queries and scripts for deployment of features in the sandbox and production database. The data extraction would need to be done from AWS S3, data warehouse, including obtaining data from multiple external API’s. Please answer following 3 questions. These questions are important
I want someone expert to help with the topics and he has good experience with programming
...particularity of confidentiality. Type of Freelancer ----------------------------------- Efficient Java Android Developer with Experience in Google Map API, Geo-fencing, SQLite database queries Deliverable: Fully Tested Java Android Code with Appropriate coding comments. Technology: Java with reusable JDBC Query interface on Android Side, SQLite as local back
We need a MySQL Coder who can write a Stored procedure or Join Queries, I have a PHP code that is timing out so the whole logic of the PHP page has to be written in SQL Queries there are less then 6-8 tables to pull data from. The work has to be done on TeamViewer
...to the files where the requested query is available. but when I search for a long/full sentence of (e.g.: what is the capital city of India) it is unable to find it in the database even if it exists. it is successfully working when I query with a single/double words but not when I search for a full sentence. I need an upgrade for this tool where as
To develop & provide support on classic windows based DESKTOP using Microsoft .NET Framework 4.0 or higher, Experience on SQL Server 20...support on classic windows based DESKTOP using Microsoft .NET Framework 4.0 or higher, Experience on SQL Server 2014 or higher (viz. writing SQL queries, creating views, stored procedures & other database objects)