Hacker News Reader

Comment by minitoar | Hacker News Reader

Ok but that is a rather clickbaity title. The title makes it sound like they are successfully doing that.

Hey, sorry for the misleading title. I started with ‘Fast SQLite Inserts’ and it had many iterations. In the title, I wanted to intend that I want to insert 1 billion rows under a minute on my machine. I thought the current title is fine, since I got LGTM for earlier drafts. The detail about on my machine is also important since mine is a two year old laptop and all the measurements are done on it.

Also I got another feedback that title should indicate that it is a test database and emphasise that it is not durable.

I am wondering the right way to convey all of this in the title yet also keep it short.

I hate hyperbole but i think the title is fine.

Thanks for the explanation. I think it only needs a minor tweak. Maybe prefix with “trying to” or something like that. I am empathetic to the challenge of naming things concisely and accurately.

Hey, I read all the suggestions and prefixed the title with "Towards ...". I hope it makes it clear now

Attempting 1 Billion Row Inserts in under 1 Minute

Achieving 100m SQLite inserts in under a minute.

>I am wondering the right way to convey all of this in the title yet also keep it short.

Add "trying":

"Trying to insert 1 billion rows in SQL in under a minute".

If anything it's more interesting because it implies the chance of failure.

Perhaps "Towards Inserting 1B Rows in SQLite in Under a Minute" would be a better title.

Thanks for this suggestion and I have updated the title!

I agree. While the title reflects the eventual goal of the effort, the goal has yet to be achieved (and may or may not be achievable at all). I think it’s a bit irresponsible to use a title like that for a post that neglects to have achieved what was described in the title.

Perhaps "Working towards 1B rows in under a minute" would have been better.

Reply on news.ycombinator.com