Hi Everyone,
I have program a payrol calculating web application. It seem to perfect at initial. However when It loads very very slow when It comes to load a report page when you can select calculating from which date to which date.. The more date you select, the page loads slower..
So I need those who really have optimizing MySQL database experience solve this problem..
Thanks
Dear Sir:
Thx for Ur project. We can do it. We r very much interested to do....
U can depend on us...
We r new in this site. That’s why our review is 1. But u can check our profile... u find some very much standard on going projects on our hand form GAF...
Then u can easily decide what we can...
Plz check PM for details
Best Regards
Iffat
epsilonsoft
I have had to deal with high volume MySQL problems a lot for people and have always found a good way to fix them. I will look thorugh your script, investigate both the php coding and the MySQL structure and will optimize both to improve your loading times signficantly.
I can get started on this today.
I can have this done today - I have recently worked on optimizing a mysql book database of 5.2m records. I can show you examples of the efficiency and speed of the database as a reference for my work. You can't go wrong with me!
Hi,
The problem probably is in your PHP code rather than mySQL.
mySQL is rather difficult about dates. It expects YYYY-MM-DD format which people are not used.
Probably the PHP code written to handle the dates is not working properly.
If you could send me the source files and give access to your FTP server, I can send back the corrected files after testing.
I regularly do projects here.
Please check th eid 'vdhara'
THanks
VDhara