MySQL Forums
Forum List  »  Performance

Re: Best setup for this table?
Posted by: Mohammad Azmath
Date: February 09, 2005 12:52AM

Great Puzzle...

Only solution is using indexes.

Table size is not the issue...
Issue is how you manage your table with indexes... and perfomance tuning options like cache management.


I worked with table with millions of records but properly indexed will return results very fast.

One more suggestion could be
if your client can bare the cost of Enterprise MySql edition please go for it for real thrill.

All the best :)

Options: ReplyQuote


Subject
Views
Written By
Posted
2339
February 01, 2005 06:01AM
Re: Best setup for this table?
1669
February 09, 2005 12:52AM
1701
February 11, 2005 09:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.