Help: Working with big database

[Mysterio]

Hello all,

I am having this kind of problem:

I have a table which have 7000 rows, and those rows are articles. This means, each row contains a title, content, keywords, description, and many different statistics. My problem is that, in the main page (homepage) I must query six times to this table, because I have to display top 3 most readed articles (order by content.views), last added and last updated (content.addedtime and content.updatedtime), and so on for some other fields.

Doing all this takes a lot of time, and soon, articles will be up to 10000 and more.

What do you suggest me?
Maybe fetching all table to a multidimensional array? How to work with it later?
What about array_multisort()?

p.s. I don't want someone to do my work, I just want suggestions.

Thanks!

[standalone]

Hi Mysterio3

hope this helps

Clustering the databsase

Very large tables in SQL Server - Stack Overflow

or Optimizing the database with few other techniques this interesting would help you most probably

http://peter-zaitsev.livejournal.com/2004/07/18/

[Mysterio]

None except standalone answered? Thank you!

I solved it with array_multisort()