WampServer

Hi there,

I installed WAMP on a Windows Vista machine, brand new computer with 1 GB memory. I built an application in PHP using MySQL. It was all running smoothly until there were more and more records to process through. The main database now has 700+ records (customers) that the pages are searching through, and its now taking like 10 seconds for each search. (searching by phone number). We tried adding more memory, but it didn't make a difference.

Does anyone know of a way to make it run faster? Is it becasue it's Vista? Or using Exporer 7?

Here's a link to a demo of the application, which is running on a real server.
[www.zoozsolutions.com]

Thank you very much,
Shane

since at home (belgium) that functions quickly and well.

searching though 700 records is something mysql should not have any problem searching through. it is blatantly obvious that you have not setup your mysql database to take advantage of mysql's powerful features. you need to learn how about database datatypes and how to use them. you also need to learn database normalization. I have made recent posts with these subjects at my Web Development for Newbies blog. I also suggest you search google for topics like "full text searching", "indexes", "innodb", etc.

Here are some links to help you get started:

MySQL Datatypes
http://webdevnewbie.com/2007/06/14/mysql-datatypes/


An Introduction to Database Normalization
[webdevnewbie.com]

InnoDB Overview
http://dev.mysql.com/doc/refman/5.0/en/innodb-overview.html

Column Indexes
http://dev.mysql.com/doc/refman/5.0/en/indexes.html

How MySQL Uses Indexes
http://dev.mysql.com/doc/refman/5.0/en/mysql-indexes.html

Make Your Data as Small as Possible
http://dev.mysql.com/doc/refman/5.0/en/data-size.html

Drawbacks to Creating Many Tables in the Same Database
http://dev.mysql.com/doc/refman/5.0/en/creating-many-tables.html

Optimizing Database Structure
http://dev.mysql.com/doc/refman/5.0/en/optimizing-database-structure.html

Full-Text Search Functions
http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html

Fine-Tuning MySQL Full-Text Search
http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html


CyberSpatium
----------------------
WAMP English Forum Admin

Need help? Check out my WAMP User Manual/Guide here!


Cellular Phone Deals - The Best on the Net! - FREE PHONES! Take your pick from our featured cellular phone deals by Cingular, Verizon, T-Mobile, Sprint PCS, Nextel, and more! Most of our cellular phone offers include a FREE cellular phone with FREE shipping!


Web Development for Newbie's Blog - Check out my new blog. It is for web developers, and especially tailored for the web development newbie. If you are not fluent in “geek speak”, then this incredible resource is just you. And even if you are a web development pro, this is a great resource to check out some of the latest web development tips, news, tutorials, codes and more.


Mortgage and Home Loan Advice:
Clarify Loans

I figured it out! Well with CyberSpatium's help of course. As soon as I added indexes to the tables, WHAMO super fast! Thank you so much!

Shane