Log in or Sign up
Coin Talk
Home
Forums
>
Coin Forums
>
Ancient Coins
>
Confused about Leu bidding
>
Reply to Thread
Message:
<p>[QUOTE="kirispupis, post: 8233544, member: 118780"]My suspicion is the system tracks pre-bids vs live bids in separate tables. This makes sense since the pre-bids generate far less performance/concurrency concerns than the live portion. When you update your pre-bid, it just increases your current pre-bid while keeping the timestamp (which may be necessary when resolving conflicts).</p><p><br /></p><p>During the live stage, each bid is entered into another table. It's then possible to read the bids with the appropriate data concurrency model without a transaction, or if this is some in-memory data structure, a short read-lock. This maximizes the performance.</p><p><br /></p><p>The ability to view bidding history was obviously added after this system was created. Since not all bidding records were necessary to compute the highest bidder, the programmer was only able to output the existing rows.</p><p><br /></p><p>Therefore, my previous "automatic" bid of 550 is not listed because it occurred during the pre-bid portion, and the system was able to calculate the maximum bid easily given the current table contents. There's no need for a separate row except for data reporting, which as I mentioned was clearly added afterwards.</p><p><br /></p><p>However, the live portion does require a more robust system requiring that two-step process, and therefore each bid has its own row that shows in the summary.</p><p><br /></p><p>There's no bug here other than lazy programming.[/QUOTE]</p><p><br /></p>
[QUOTE="kirispupis, post: 8233544, member: 118780"]My suspicion is the system tracks pre-bids vs live bids in separate tables. This makes sense since the pre-bids generate far less performance/concurrency concerns than the live portion. When you update your pre-bid, it just increases your current pre-bid while keeping the timestamp (which may be necessary when resolving conflicts). During the live stage, each bid is entered into another table. It's then possible to read the bids with the appropriate data concurrency model without a transaction, or if this is some in-memory data structure, a short read-lock. This maximizes the performance. The ability to view bidding history was obviously added after this system was created. Since not all bidding records were necessary to compute the highest bidder, the programmer was only able to output the existing rows. Therefore, my previous "automatic" bid of 550 is not listed because it occurred during the pre-bid portion, and the system was able to calculate the maximum bid easily given the current table contents. There's no need for a separate row except for data reporting, which as I mentioned was clearly added afterwards. However, the live portion does require a more robust system requiring that two-step process, and therefore each bid has its own row that shows in the summary. There's no bug here other than lazy programming.[/QUOTE]
Your name or email address:
Do you already have an account?
No, create an account now.
Yes, my password is:
Forgot your password?
Stay logged in
Coin Talk
Home
Forums
>
Coin Forums
>
Ancient Coins
>
Confused about Leu bidding
>
Home
Home
Quick Links
Search Forums
Recent Activity
Recent Posts
Forums
Forums
Quick Links
Search Forums
Recent Posts
Competitions
Competitions
Quick Links
Competition Index
Rules, Terms & Conditions
Gallery
Gallery
Quick Links
Search Media
New Media
Showcase
Showcase
Quick Links
Search Items
Most Active Members
New Items
Directory
Directory
Quick Links
Directory Home
New Listings
Members
Members
Quick Links
Notable Members
Current Visitors
Recent Activity
New Profile Posts
Sponsors
Menu
Search
Search titles only
Posted by Member:
Separate names with a comma.
Newer Than:
Search this thread only
Search this forum only
Display results as threads
Useful Searches
Recent Posts
More...