Keiter: Lucid: an eternity, by today’s standards.
Trowbridge: Keiter: yeah but that’s the flat-wrong query. The like query alone is 0.02s
Loveland: Keiter: select * from Sellers WHERE name LIKE ‘the%’;
Keiter: Lucid: see salle’s comments.
Ruoho: Trying to understand MAXrank
Tippens: Salle: Interestingly, the spec even allows for functional dependencies between based tables in one server and ‘foreign table’s of a foreign server. But these are not guarenteed.
Shroff: I know what it does, but I don’t know why I’d want the max rank
Keiter: Lucid: to answer that question, you need to understand how aggregation works, and what a functional dependency is
Remele: Given a search input I want the seller’s name, current rank todays date, days since last rank update probably 1 day or 7 days, and the change in rank
Keiter: Lucid: well, how do you think you’ll track down rank changes?
Barranger: Keiter: I was expecting to do it by date
Keiter: Lucid: be more specific.
Animashaun: Hello. How much ram does MySQL need for a smallish database?
Duckwall: Keiter: select rank, date from Ranks where sellerId=1234 ORDER BY date DESC LIMIT 2;
Gribbins: 0,5 GB of ram should do it ?
Awyie: Keiter: the reason I think MAXrank is hard is because I need them in order of the dates; rank can go up or down so current rank might not be the max rank, the max rank is sort of ambiguous
Keiter: Smurfke: seriously, we can’t answer that question unless you tell us how much available RAM you have, how much data and indexes you have.
Keiter: Lucid: how do you populate the ranks table?
Toca: Keiter: ah ok I’m sorry, cannot estimate it yet
Holtmann: Keiter: from a 3rd party source
Keiter: Lucid: be more specific
Keiter: Smurfke: how much available RAM do you have?
Galik: Keiter: from a website with a big list of links, and I take all the links and figure out which page and which place on the page and calculate the rank
Wainio: Keiter: so page 1 spot 1 = rank 1. page 2 spot 1 = rank 51. etc
Keiter: Lucid: in that case, you can join the ranks table n times, depending on what you need from it.
Keiter: Smurfke: a good starting point might be 50-60% of that, if you have that much data and indexes
Vardaman: Keiter: is this kind of thing evil? select select rank from Ranks WHERE sellerId=1234 ORDER BY date DESC LIMIT 1 – select rank from Ranks WHERE sellerId=1234 ORDER BY date DESC LIMIT 1,1;
Paillant: Keiter: that’s the change value I want, but then each of those is a dependent subquery :
Koestler: I don’t know if it matters that the queries are very limited in scope or not. I don’t see how you can deterministically get the past 2 ranks for a particular sellerId without the sellerId!
Damour: Keiter: that particular example has the sellerId hardcoded, but in a query with joins and the like, wouldn’t it?
Samowitz: Keiter: oh because its in the select for that sellers details in the queries?
Keiter: Lucid: I think you’re still confused.
Celis: Keiter: my problem is that it bridges two tables with conditions
Mcguirt: As soon as that happens I start wanting to do all kinds of crazy things that I know are wrong
Keiter: Lucid: so joining table in subqueries makes it dependant?
Elchert: Keiter: so you’re back to the “joining Ranks n times” thing.
Asiello: Keiter: I’ll see if I can figure that out
Keiter: Lucid: no, I’m just trying to clarify a few of your misconceptions.
Keiter: Lucid: you have a long way to go before you can solve your problem
Boilard: Keiter: am I understanding that you’d want to join the Ranks table twice in that case, for LastRank and CurrentRank?
Keiter: Lucid: you could, possibly.