How many entries can Mysql hold

a720

I am thinking of building a search engine and was wondering how many records mysql could hold.

Users will submit there site by adding the following info to the database.

field 1: url
field 2: title
field 3: keywords

is there any other way of doing this, i.e by allowing users just to submit there url and short description. This gets stored in mysql but when a user does a search it searches through the websites meta tags any ideas?

hand

You can do everything you want. After user submits the url you can read the content of the url and analyze it.

$fp = fopen ("http://www.example.com/", "r");

After analysis you can store the data to your db.

mw-dnb

Originally posted by hand
You can do everything you want. After user submits the url you can read the content of the url and analyze it.

$fp = fopen ("http://www.example.com/", "r");

After analysis you can store the data to your db.

You learn something new everyday. Great example 😃

That just made my gears start movin hehe!

[deleted]

Getting back to your original question:

"and was wondering how many records mysql could hold. "

more than you'll ever need, but by the time you get to a few thousand rows, mysql tends to become very slow on complex queries. (ie: saerching for data) Fetching a single row is still fast, but queries like ' SELECT url FROM table WHERE name LIKE '%hello%'; become very slow.