MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: How to get acceptable/repeatable performance on huge table
Posted by: Peter Stridsberg
Date: August 31, 2012 07:30AM

Unfortunately, we need really fast access to all rows with a specific Uid, thats the most important function of this table. (We do in the order of 1000 such lookups per sec and can't accept loosing performance there).

We have good peformance with that today but it would become worse with an ordinary Uid index - don't you agree?

Would not an additional index (adId, uid) do the same thing as rearranging the PK?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
How to get acceptable/repeatable performance on huge table
2320
Peter Stridsberg
August 30, 2012 03:07AM
Re: How to get acceptable/repeatable performance on huge table
1159
Aftab Khan
August 30, 2012 03:55PM
Re: How to get acceptable/repeatable performance on huge table
1005
Peter Stridsberg
August 31, 2012 05:22AM
Re: How to get acceptable/repeatable performance on huge table
1138
Øystein Grøvlen
August 31, 2012 05:42AM
Re: How to get acceptable/repeatable performance on huge table
1017
Aftab Khan
August 31, 2012 05:43AM
Re: How to get acceptable/repeatable performance on huge table
1099
Peter Stridsberg
August 31, 2012 05:54AM
Re: How to get acceptable/repeatable performance on huge table
1137
Aftab Khan
August 31, 2012 07:00AM
Re: How to get acceptable/repeatable performance on huge table
1082
Peter Stridsberg
August 31, 2012 07:30AM
Re: How to get acceptable/repeatable performance on huge table
1073
Aftab Khan
August 31, 2012 07:44AM
Re: How to get acceptable/repeatable performance on huge table
1075
Peter Stridsberg
September 02, 2012 09:27AM
Re: How to get acceptable/repeatable performance on huge table
1159
Aftab Khan
September 03, 2012 03:17AM
Re: How to get acceptable/repeatable performance on huge table
988
Aftab Khan
August 31, 2012 08:12AM
Re: How to get acceptable/repeatable performance on huge table
1100
Rick James
September 01, 2012 06:39PM
Re: How to get acceptable/repeatable performance on huge table
992
Peter Stridsberg
September 02, 2012 09:25AM
Re: How to get acceptable/repeatable performance on huge table
919
Peter Stridsberg
September 02, 2012 09:32AM
Re: How to get acceptable/repeatable performance on huge table
1082
Rick James
September 02, 2012 11:22AM
Re: How to get acceptable/repeatable performance on huge table
926
Øystein Grøvlen
August 31, 2012 04:47AM


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.