Quote Originally Posted by Molly_Millions View Post
I do have experience working with databases that contain numbers of accounts about 10 orders of magnitude larger than the numbers on each world server. We can query that database joining about 20 to 30 tables and receive results in a matter of seconds. It's obvious from the reps response that the LS ui query uses a single table. Something doesn't sound right to me.
I agree with most of this (I have exp in large databases myself), but one thought occurs to me: what if they don't consistently store it in another accessible table either? It sounds like they are using a single table design for LS, and for FC.

I.E. they are storing the date in the FC table. Which means the only way to get this would be to join to the FC table, which not everyone has.

It could be literally as simple as, they can't do it reliably because the data is only stored in the FC table. So LS -> left join Players -> left join FC, it still might not show if the person isn't currently in a FC.

I know this should be easy, I agree. But it does sound like a potential schema change would be required and nobody wants to sign off on a schema change in a live environment. No matter how trivial. Not in my experience anyway.