How can I creat database.(200.000 record).

Hi everyone

I take a project. I will use php and mysql. I finished some projects. But all of them dont have big database. The biggest one is 20.000 record.
Now this is 200.000 record and 94 client will connect database. The clients are in diffrent location and city. They will insert,update data, take list, search record, etc.
What will I do and how can optimize database.

First of all, I would make sure you have a really fast server...

And second, make sure that the database you are using has no 'extra' fields, or fields that are to long.
What I'm trying to say is, if you have a text-string that is 20 characters maximum, don't make a database-field (like VARCHAR, if you use MySql) that is 100 characters long.

It's also advisible to use linked tables, i.e: one user table (tblUsers), with the field UserId, and one table with the data, like tblData, and link the tables together.

So, if you need a username, you can extract it from tblUsers, by storing only the UserId in tblData, instead of the whole username.
This will keep your db as small as possible.

I hope you get the point, my English isn't that great...

These are all the advises I can give you, I hope they are usefull to you...

Good luck,

djxtension

Thanks for your help djxtension

See you