dr_strangelove
Re:Arc browser launches its Windows client in beta
on Wednesday December 13, 2023 @08:09AM (#38626786)
The architecture is described here:
Re:Spreedly Core - API powered payments w/o burden of PCI compliance
on Wednesday February 23, 2011 @01:59AM (#2253377)
For german users a similar service is offered by 1&1 (iPayment, with "silent CGI"-mode). The form on the site is sent to the ipayement servers and those verify the transaction data, call a URL on your servers with the unique transaction token and success/error message, and only redirect the user back to your site after the callback is finished. Works pretty well, the credit card data never touches your server but the user doesn't notice that he left your site.
Re:D-Term: Mac app to automatically contextualize command line with fo...
on Sunday April 18, 2010 @05:56AM (#1274615)
To open a terminal simply press cmd + return.
Re:MySQL and partitioning tables with millions of rows
on Sunday January 31, 2010 @03:50PM (#1091062)
if you had an index on device_id there shouldn't be a difference in performance between the original table and the partioned one. the index is used to reduce the rows that need to be scanned so there wouldn't be a full table scan. btw, why do you use a table lock?
Re:MySQL and partitioning tables with millions of rows
on Sunday January 31, 2010 @03:37PM (#1091037)
had this guy an index on "device_id" and "date_added", there is no way such a query would take 3-4 seconds.
Re:Harder, Better, Faster, Stronger: New Features in Postgres 8.4
on Friday April 24, 2009 @12:53PM (#577761)
To give you a background why vacuum is necessary: When you update a row in postgres, it is marked as deleted and a row with the updated contents is inserted. Likewise, when you delete a row, it is only marked as deleted but the space on disk will not automatically be reused. The vacuum process appends all these rows to the list of reusable rows.
If the autovacuum process is run too infrequently, the space used by the tables grows larger and there are many gaps between used rows. In addition to filling up more disk space than necessary this reduces sequencial scan performance. In this case you should run a vacuum full which packs the table and relases the unused space to the operating system (think of file system defragmentation). Unfortunately this is quite slow and uses table locks so you should not do it on a production system.
[EDIT:] From the awesome postgres documentation:
http://www.postgresql.org/docs/current/static/routine-vacuum...
Re:Harder, Better, Faster, Stronger: New Features in Postgres 8.4
on Friday April 24, 2009 @12:24PM (#577702)
You don't need VACUUM FULL. If you have problems with too much disk space used by your tables, increase the autovacuum frequency.
Re:Ask HN: can you summarize OO for me in 64 words or less?
on Tuesday November 18, 2008 @01:30AM (#367949)
The language that fits this description best is Erlang, I would say ... (what, in this definition, is specific to objects compared to processes?)