Another question regarding database

I plan to hold 100,000 rows on my directory

and to search to it

What power I require for the server?

I am currently hosting at 2100 GB shared hosting at servage will it be enough?

or I want to look for a dedicated server

 

100,000 rows in a database is really not that much. Your current host is most likely good enough.

 

Thanks a lot

And also whether a query over 100000 rows will take too much time

 

It depends on the query. If you are just selecting from that 1 table, the performance won't matter that much at 100,000 rows. An easy way to make queries go faster is by adding an index on columns that you use in your where clause.

 

I agree. Its doubtful you will have any problems.

 

I plan to have search queries from more than one table

So I could reduce the load on the server

 

This is exactly what mysql is designed ( so well ) to do, you won't have any issues on a dual processor / core machine, I wouldn't recommend anything less not because of mysql, but becuase of cpanel it sucks under strain and if a load of people are loggin into thier cpanel at the same time as some visitors want to search the mysql process gets a lower priority so the people at cpanel can keep fooling people into buying a liscence for it.

So yes and no, whilst in development you'll be fine and up to a point if your host doesn't oversell too much, but who wants to build a house on the beach and then move it up a tree

 

I do not have a cpanel

I am just talking about a searching within a directory

 

I m not sure whether mysql has any performance monitoring system. I mostly use MS Sql.

Monitoring search peformance and smartly building your query you could increase search formance.

 

You can use "explain" on your queries to check how well they are optimized.

 

are you talking about explain statement in SQL?

 

Yes plz. tell r u looking of a sql statement.. for MySql or Mssql or what?