| View previous topic :: View next topic |
| Author |
Message |
Pilgrim

Joined: 28 Feb 2008 Posts: 20
|
Posted: Fri Feb 29, 2008 10:25 pm Post subject: City marketplaces list items multiple times |
|
|
When I'm looking at the luxuries in a city's marketplace, sometimes the "next 20" button gives inconsistent results, like items being listed in two different places, and other items not listed at all.
I discovered this when I was cutting and pasting entire marketplaces into a spreadsheet and then sorting by item name. It doesn't happen all the time. There's a usual order in which the luxuries are listed (I'm only tracking luxuries), and when I see that order, I know I'm ok. But when the luxuries come up in a different order, then I double-check and sure enough, there are duplicates and missing items. |
|
| Back to top |
|
 |
John

Joined: 09 Oct 2007 Posts: 392
|
Posted: Sat Mar 01, 2008 2:45 am Post subject: Re: City marketplaces list items multiple times |
|
|
| Pilgrim wrote: | When I'm looking at the luxuries in a city's marketplace, sometimes the "next 20" button gives inconsistent results, like items being listed in two different places, and other items not listed at all.
I discovered this when I was cutting and pasting entire marketplaces into a spreadsheet and then sorting by item name. It doesn't happen all the time. There's a usual order in which the luxuries are listed (I'm only tracking luxuries), and when I see that order, I know I'm ok. But when the luxuries come up in a different order, then I double-check and sure enough, there are duplicates and missing items. |
Do you have specifically which city and kind of search you were doing? I don't see duplicate city items in the database so it's probably a bad search. |
|
| Back to top |
|
 |
Pilgrim

Joined: 28 Feb 2008 Posts: 20
|
Posted: Sat Mar 01, 2008 10:02 pm Post subject: |
|
|
It happens intermittently. I'll try to take notes the next time it happens.
I'm not a database expert, but I suspect that instead of getting a whole search done and just displaying the results in pages, that each page is a new search and the order of search or the underlying index changes between "next 20" pages. |
|
| Back to top |
|
 |
|