Slow DB.

Anon

Hi, I'm using MYSQL w/ PHP and recently my page loads are really slow. My DB size is approaching 2 megs. Is this big? So big that it would cause it to slow down a lot? I don't do THAT many calls to the DB.

thanks in advance.

[deleted]

"Is this big?"

Nope, 2TB is big, 2MB is peanuts.

Do you have proper indexes on your tables?

A forum, a FAQ, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

mwilson

The performance of your database depends on a lot of things. It could be down to server load or maybe your SQL queries or maybe one of a hundred other things. Without more information I doubt anyone can help specifically pinpoint the problem.

Matt

Anon

ok, I was just wondering if 2mg was big. I think it's the server or my tables. I have almost 20 fields in that table. I may split it up.

thanks.

[deleted]

2 megs and 20 fields is complete peanuts, that is not the cause of your speed problem.

I assume you're a newbie at databases, so I suggest that you read-up on the proper use of indexes on your table.

If you database does not have any indexes on any tables, it means that the database must read all your data for every query it does, and that can be very slow.

Check for indexes.
Check your query logic.
Try to find out which query is slowing you down and post it here so us 'geniouses' can have a look at them for you.

Anon

ah so indexing basically makes it faster .... haha, I never knew about that and yes, I'm fairly new. It's much much faster now ... thanks.

[deleted]

A word of warning:
indexes make your query faster because they are basically a compact version of the real table. The index only contains those columns that you defined the index on. All the other data in the table is ignored. That means that if your query needs the data that's in your index, it can read the (very small) index quickly instead of having to read all the other data too.

Don't define an index on all columns at the same time, because then you just have a 1:1 copy of the table, and that's just as slow.

Define indexes on the columns that you use in your query, on as few columns at a time as possible.