Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
owkaye
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
19 ms
·
121.
▲
by
owkaye
18y ago
I've created a (hopefully) more organized thread with some details this one does not have. Please go to this thread to continue this discussion, thanks: http://news.ycombinator.com/item?id=362810
122.
▲
by
owkaye
18y ago
it's an auction based on a gaming concept, more details here: http://news.ycombinator.com/item?id=362810
123.
▲
by
owkaye
18y ago
Thanks mleonhard, I've created a new thread to continue this discussion since this one has become way too disorganized, so please post future replies here: http://news.ycombinator.com/item?id=362810
124.
▲
by
owkaye
18y ago
Legal and financial issues are outside the topic of this thread, but I will say this: If the auction proceeds to completion the RAM data is written to disk. This file becomes the 'auction log'. If the auction fails to complete because of
125.
▲
by
owkaye
18y ago
NOTICE ! THIS THREAD IS BEING MOVED !!! I'M GOING TO START A NEW THREAD TO CARRY ON WHERE THIS ONE LEAVES OFF SINCE THINGS HAVE BECOME SUCH A MESS IN THIS THREAD ... AND I'M SHOUTING TO MAKE SURE EVERYONE KNOW ABOUT THIS SO THEY CAN FIND A
126.
▲
by
owkaye
18y ago
Topic: GENERAL PLAN OF ACTION lallysingh said: "So, for advice: 1. Ignore database bullshit. You don't need it, it won't help. If you want a DB for other purposes, fine. A snapshot process writing to your DB is fine, just don't put it in th
127.
▲
by
owkaye
18y ago
Topic: LOAD TESTING DURING DEVELOPMENT owkaye (that's me) said: "This is not a system I can grow into, it must be capable of this performance from the very beginning." then ericb said: "I would suggest you load test extensively and make loa
128.
▲
by
owkaye
18y ago
Topic: ONE OR MORE SERVERS FOR THE DATA? ig1 said: "Figure out how to partition your data/algorithms so you can split it across multiple machines..." but lallysingh said: "A single dell box could handle your load if you wrote the whole thin
129.
▲
by
owkaye
18y ago
Topic: MY EMAIL ADDRESS, TOP OF THE PAGE lallysingh said: "If you're doing something game-ish, talk to me privately. Scalability of video games is my phd topic." my reply: It certainly seems like I'm doing something 'game-ish' although it'
130.
▲
by
owkaye
18y ago
TOPIC: CUSTOM DATABASE STRUCTURE IN RAM? ig1 said: "I've worked on a number of high volume systems (million+ client interactions/minute), and you don't want a conventional database. Either use a custom data-structure to keep it in memory (e
131.
▲
by
owkaye
18y ago
Tech Issue #4 - BATCH PROCESSING? I've never done batch processing before, but some have suggested it, and I don't understand how it works just yet. My current concept is that I would receive (for example) 15,000 bids during a one-second p
132.
▲
by
owkaye
18y ago
Tech Issue #3 - KEEP-ALIVE OR BROWSER PLUG-INS? If a connection can be opened and remain open for the entire hour-long auction this might dramatically reduce the overhead of individual HTTP connections. Is something like this possible with
133.
▲
by
owkaye
18y ago
Tech Issue #2 - CAN JAVASCRIPT SPEEDS THINGS UP? If I understand correctly, some have said Javascript in the browser can reduce or eliminate the HTTP overhead and dramatically reduce both data transfer and bandwidth requirements. Is this tr
134.
▲
by
owkaye
18y ago
Tech Issue #1 -- WRITING DATA TO DISK I've always used a database to accomplish tasks like these before, but it seems that what I really need is a faster (RAM-based) way to receive and store every bid value received during the hour-long auc
135.
▲
by
owkaye
18y ago
Business Detail #4: CLOSED BIDDING WITH LIVE STATUS REPORTS Every bid is a "closed bid" which means no other bidders know its actual value. Bidders are given the "status" or "position" of their bids in relation to the current unique high b
136.
▲
by
owkaye
18y ago
Business Detail #3: ONE MILLION HITS A MINUTE MAX Each bidder who remains online and participates during the auction may submit as many as 5 new bids per minute, thus requiring the server to "deal with" as many as one million hits a minute.
137.
▲
by
owkaye
18y ago
Business Detail #2 - LIMITED NUMBER OF BIDS Every bidder gets the same limited number of bids in a particular auction, for example 200 bids each. This means the server software must "count the bids" for each bidder and disable bidding for
138.
▲
by
owkaye
18y ago
Business Detail #1: IT'S A LIVE ONLINE AUCTION I'm not at liberty to discuss the industries or specific applications in which this platform will be used so please don't ask. But I can tell you that the platform is structured like a live o
139.
▲
by
owkaye
18y ago
Yes, eliminating the sorting is a better way to approach the problem I believe. I've always just 'sorted' to determine a new record's position in the list, but it seems there may be other (more efficient) ways to determine the record's pos
140.
▲
by
owkaye
18y ago
In my last long post I said Retric was wrong about providing data that's accurate only to +/- .2 seconds, but maybe I'm the one who is wrong. It is possible that I completely misinterpreted his meaning. I became aware of this possibility
141.
▲
by
owkaye
18y ago
I'm not showing them all that user-provided data, all I'm showing them is the position of their last post relative to the position of 'another post' in the database. The 'other post' changes from time to time based on an algorithm that take
142.
▲
by
owkaye
18y ago
Retric said if I provide data that's accurate +/- .2 seconds that's close enough, but he's wrong (sorry Retric, it's not your fault). The fact is, I must provide each member with the relative position of his post each time he makes one, an
143.
▲
by
owkaye
18y ago
Here are my answers / comments to some of the recent posts (more replies to come). Thanks again to everyone for your help and please keep your suggestions coming: to swombat: The clients will have javascript so short commands rather than e
144.
▲
by
owkaye
18y ago
Wow, I was writing a reply to davidw's first post when lots of new posts arrived in this thread. Thanks to all of you! I haven't read any of your new posts yet but I will as soon as I submit this one: The concept is a live interactive syst
145.
▲
Ask HN: How do I handle a million hits a minute?
45 points
by
owkaye
18y ago
|
63 comments
146.
▲
by
owkaye
18y ago
Why don't you just accept the fact that he's no good at estimating how long it will take him to accomplish something, then just add a number of extra days to his estimates so you're not disappointed any more?
147.
▲
by
owkaye
18y ago
Sounds interesting, please keep me informed if you can, I'm at owkaye (at) gmail (dot) com, thanks!
148.
▲
by
owkaye
18y ago
I used to use my own domain email for more than a decade and now I use gmail exclusively. Why? First of all they have the best spam filtering system I've ever been exposed to. Second, they archive all my email and each account has a limi
149.
▲
by
owkaye
18y ago
I'm using name.com which costs me $6.99 per year for the first year, although I don't know what renewals will cost since this is my first year: "For a limited time you'll be able to take advantage of $6.99 pricing for new .com registrations
150.
▲
by
owkaye
18y ago
I'll let you email me since I don't see any link to your email address: owkaye (at) gmail (dot) com.
More ›