Database Overload?

[phpretard]

I plan on importing 3-5 thousand entries at once (all is text).

 

Each entry has 20 pieces of information. (ie. name, address, phone, and so on...)

 

I will input these once per week.

 

How much information is too much for one DB.

[MadTechie]

Depends on the size of your harddrive..

[phpretard]

It is actually a godaddy hosted site.

[MadTechie]

Okay.. depends on the allocated space..

you can put as much data in until the drive it full!

[phpretard]

10-4

 

Will this affect the speed of the site?

[MadTechie]

Not if the site doesn't use the database, if it does use the database it depends on the design and use.. very hard to say but yes more data slows it down, (badly if it has a bad design)

[phpretard]

Thank you very much for your advice...

 

Any more thought would be appriciated!

 

-Ant

[MadTechie]

Okay.. simple table 20 fields (with a unique ID) 20000000 records

 

your ID is index'd and an autonumber primary field..

you search/link only by ID, not a problem

 

Now lets say you have a 8 inner join linking unindex'd fields using a select in a select..

probably going to get a timeout..

 

okay if they were index'd 8 joins (or even the select in a select by itself) may of killed it anyways but you get the point