Website Database Work

A proposal has not yet been provided

Hi soyebmandal, From what I understand, you have two problems here: Firstly, your database is too large - taking up more disk space than your host would like. Secondly, your website is transferring too much data from the database to be used by the site. I'm a database developer with over 10 years experience working for the UK's largest retail banking group. I have completed numerous projects, building and refining database applications for customers who need to keep their costs down. To resolve the first problem, I would ensure that your database is as normalised as possible. This means removing duplicated information by storing it separately and using database relationships so that all information is still available to your website. To resolve the second problem, I would rebuild your SQL queries. The chances are that they use "Select * From" fairly often, and this needs to be changed to only load the information that's required. To ensure that you're happy with my solution, I would have a look at your database and provide you with a plan of the work I would do. Please feel free to ask any questions you may have. I'm not the cheapest option in your list of candidates, but I have a lot of experience and will get the job done for you. Kind regards, Ben

A proposal has not yet been provided

Hi, Please let me work on this project. I have more than 5 years of experience on PHP and MySql. I had already done many performance improvement projects. Also I am an Oracle certified database administrator. I will surely help you out by removing extra useless joins that makes your sql queries slower. Thanks, Rahul

Hi, I have experience in database handling of more than 10 years. Have worked on large ERP solutions for School and Hospital management solutions built in PHP/MySql. Have worked on CRM solutions for sectors like Finance, Universities, Retail Chains and many more. Please provide access to your setup or ask your hosting company to provide Slow Query logs or more specific details about problem like which tables or Queries are consuming more resources. Thanks

Hello. I have over 5 years’ experience in the design, development and tuning of the various databases (Oracle, MSSql, MySql etc.) and I have a huge knowledge and experience to optimize slow MySQL query. I will be glad to help you. Email me and we can discuss the details. Thanks

A proposal has not yet been provided

Hi, May you link to the website? Where is this website hosted? What type of website is it? Is it hosted on a dedicated server? What is your monthly budget? May you provide the code that connects to the database and the database code itself? Regards

Hi there, I would really like to help on this project. I like the more difficult challenges. And are good with finding problems. I have solid database experience and will know what to look for. Lets have a chat if you need to clarify of just get to know each other a bit better. Sincere Regards, Albert

experienced software professional with 20 years in design, development and maintenance of applications. Your database needs to be optimized and older data to needs to be archived. Let me know how to proceed

I feel the best strategy for this would be to look at the queries and implement better indexing at the application level, but also combine this with with a caching implementation in the application. The problem cannot likely simply be solved at the database level.

I am familiar with database design and tuning. I have 6 years experience working with SQL Server. I can fix these kinds of issues by changing database design and sql query.

Hello, I'm a professionnal DBA whith experience in Oracle, Postgres and Mysql. I'm confident i can find solve the performance bottlenecks of your database. sincerely yours Eric