|
m*********y
发帖数: 389 | 2 I was trying to use SQL Server 2008's Import and Export Wizard to report
more than 1 million rows directly into EXCEL. Every time when I choose from
a list of the Excel versions they support, I chose 'Excel 2003' -- obviously
, only Excel 2003 and above version allow more than 65k records. Then I
specify the output file name and location and click 'Finish'.. However, the
wizard would ignore the version I selected for Excel, and still went ahead
and exported into an earlier versions of Excel, lik... 阅读全帖 |
|
c*****d
发帖数: 6045 | 3 同时run 10个，每个delete 4 millions record?
这个方法性能更慢 |
|
c*****d
发帖数: 6045 | 4 同时run 10个，每个delete 4 millions record?
这个方法性能更慢 |
|
l******9
发帖数: 579 | 5 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: SQL fast search in a 10 million records table
发信站: BBS 未名空间站 (Thu Jul 24 23:26:56 2014, 美东)
I need to do a fast search in a column with floating point numbers in a
table of SQL server 2008 R2 on Win 7.
the table has 10 million records.
e.g.
Id value
532 937598.32421
873 501223.3452
741 9797327.231
ID is primary key, I need o do a search on "value" column for a given value
such that I can find the 5 closest... 阅读全帖 |
|
T********i
发帖数: 2416 | 6 1万美金左右的dual sandy bridge server。两个solarflare card。
我的系统也搞了这么多年了。要说没研究过同步写异步写disk你觉得可能么？昨天故意
用磁盘这个词就是设个套让你钻的。
大家都是在纸上谈兵。你拿出来那个200多台cassandra server handle 1 million I/O
的benchmark我没异议。因为理论上可行。
我给你拿出来的第三方厂商的benchmark你信不信？如果你不信，你要指出理论上不可
能。不能号称人家和你一样蠢做不出来。
再说了，那个200多台的benchmark是别人做出来的。你还不一定有这个本事。几个
million I/O是我自己做出来的，而且我有硬的benchmark。
你要承认单机能做出来。那么很显然我的方案是当前技术能达到的极限。比你的便宜，
简单，而且比你上百台服务器的性能还好。 |
|
l******9
发帖数: 579 | 7 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: SQL fast search in a 10 million records table
发信站: BBS 未名空间站 (Thu Jul 24 23:26:56 2014, 美东)
I need to do a fast search in a column with floating point numbers in a
table of SQL server 2008 R2 on Win 7.
the table has 10 million records.
e.g.
Id value
532 937598.32421
873 501223.3452
741 9797327.231
ID is primary key, I need o do a search on "value" column for a given value
such that I can find the 5 closest... 阅读全帖 |
|
s******o
发帖数: 298 | 8 By Tariq Malik
Staff Writer
posted: 07:00 am ET
03 July 2002
The mantra 'bigger is better' is popular among astronomers, who develop ever-
larger telescopes for a better view of the universe. But in Canada, where
researchers are building the smallest space telescope ever, the saying bears
no weight.
The Canadian Space Agency (CSA) plans to put its first space telescope in
orbit inside a package no bigger than a suitcase. At $10 million in Canadian
terms (about $6 million in U.S. currency), the m |
|
|
p******g
发帖数: 321 | 10 Why $70 Million Wasn't Enough
With Wall Street Rules Changing,
A Goldman Star Felt Underpaid;
Throat Lozenges for 100 Days
By MONICA LANGLEY
August 18, 2007; Page A1
New York
Mark McGoldrick earned about $70 million in pay last year -- nearly $200,000
a day -- placing bets using Goldman Sachs Group Inc.'s money. He was one of
Goldman's highest-paid employees.
Turns out it wasn't enough.
Internally dubbed "Goldfinger" for running one of Goldman's most-profitable
units, Mr. McGoldrick delivered a |
|
|
w*********s
发帖数: 2136 | 12 【 以下文字转载自 Medicine 讨论区 】
发信人: whiteclouds (/ 参考消息 /), 信区: Medicine
标 题: 美国第一宗因疫苗导致自闭症的法院判赔 -- $1.5 million
发信站: BBS 未名空间站 (Fri Sep 17 06:05:50 2010, 美东)
Family to Receive $1.5M+ in First-Ever Vaccine-Autism Court Award
he first court award in a vaccine-autism claim is a big one. CBS News has
learned the family of Hannah Poling will receive more than $1.5 million
dollars for her life care; lost earnings; and pain and suffering for the
first year alone.
In addition to the first year, the family w |
|
D********r
发帖数: 208 | 13 first question,
kt boutdary is about 65 millions years ago
and mammals starts before that, I'd guess 100 million |
|
l******9
发帖数: 579 | 14 【 以下文字转载自 Statistics 讨论区 】
发信人: light009 (light009), 信区: Statistics
标 题: count unique values in file with 1 million rows
发信站: BBS 未名空间站 (Sat Apr 12 16:11:22 2014, 美东)
I need to count the unique values in one column in EXCEL 2010.
The worksheet has 1 million rows and 10 columns. All cell values are string
or numbers.
I used the solution at Count unique values in a column in Excel
=SUMPRODUCT((A2:A1000000<>"")/COUNTIF(A2:A100000,A2:A1000000&""))
But, it runs so long time that the EXCEL is almost ... 阅读全帖 |
|
w*********s
发帖数: 2136 | 15 【 以下文字转载自 Medicine 讨论区 】
发信人: whiteclouds (/ 参考消息 /), 信区: Medicine
标 题: 美国第一宗因疫苗导致自闭症的法院判赔 -- $1.5 million
发信站: BBS 未名空间站 (Fri Sep 17 06:05:50 2010, 美东)
Family to Receive $1.5M+ in First-Ever Vaccine-Autism Court Award
he first court award in a vaccine-autism claim is a big one. CBS News has
learned the family of Hannah Poling will receive more than $1.5 million
dollars for her life care; lost earnings; and pain and suffering for the
first year alone.
In addition to the first year, the family w |
|
m******i
发帖数: 834 | 16 University of Pennsylvania gets $20 million gift for nanotechnology center
【纳米科技世界快讯】据滨州大学报道，该校的 Krishna Singh has made the
largest single gift in the history of the School of Engineering and Applied
Science at the University of Pennsylvania.
The $20 million gift will create the Krishna P. Singh Center for
Nanotechnology, a planned 100,000 square-foot facility that will serve not
only the Penn campus but the entire Philadelphia region. It will function as
a crossroads of multi-disciplinary funda |
|
b**u
发帖数: 2761 | 17 BEIJING, China--(BUSINESS WIRE)--BEIJING, CHINA, MAY 13 – Today Pfizer
China announced it is providing up to RMB 10 million (approximately $1.4
million U.S.D) in medicines and financial assistance to relief organizations
operating in the region worst affected by the massive earthquake.
“We were devastated to hear about the rising death tolls and escalating
number of injuries in Sichuan Province,” said Ahmet Esen, country manager
of Pfizer China. “Pfizer will work closely with the Chinese Governm |
|
w*********s
发帖数: 2136 | 18 【 以下文字转载自 Medicine 讨论区 】
发信人: whiteclouds (/ 参考消息 /), 信区: Medicine
标 题: 美国第一宗因疫苗导致自闭症的法院判赔 -- $1.5 million
发信站: BBS 未名空间站 (Fri Sep 17 06:05:50 2010, 美东)
Family to Receive $1.5M+ in First-Ever Vaccine-Autism Court Award
he first court award in a vaccine-autism claim is a big one. CBS News has
learned the family of Hannah Poling will receive more than $1.5 million
dollars for her life care; lost earnings; and pain and suffering for the
first year alone.
In addition to the first year, the family w |
|
h*******l
发帖数: 1542 | 19 【 以下文字转载自 Military 讨论区 】
发信人: happyhill (hello), 信区: Military
标 题: Romney's tax returns show $42-million in 2010-11
发信站: BBS 未名空间站 (Tue Jan 24 23:38:39 2012, 美东)
What does Mit Romney do everyday? How did he get $42-million in a year? |
|
l******9
发帖数: 579 | 20 【 以下文字转载自 Statistics 讨论区 】
发信人: light009 (light009), 信区: Statistics
标 题: count unique values in file with 1 million rows
发信站: BBS 未名空间站 (Sat Apr 12 16:11:22 2014, 美东)
I need to count the unique values in one column in EXCEL 2010.
The worksheet has 1 million rows and 10 columns. All cell values are string
or numbers.
I used the solution at Count unique values in a column in Excel
=SUMPRODUCT((A2:A1000000<>"")/COUNTIF(A2:A100000,A2:A1000000&""))
But, it runs so long time that the EXCEL is almost ... 阅读全帖 |
|
l******9
发帖数: 579 | 21 【 以下文字转载自 JobHunting 讨论区 】
发信人: light009 (light009), 信区: JobHunting
标 题: SQL fast search in a 10 million records table
发信站: BBS 未名空间站 (Thu Jul 24 23:26:56 2014, 美东)
I need to do a fast search in a column with floating point numbers in a
table of SQL server 2008 R2 on Win 7.
the table has 10 million records.
e.g.
Id value
532 937598.32421
873 501223.3452
741 9797327.231
ID is primary key, I need o do a search on "value" column for a given value
such that I can find the 5 closest... 阅读全帖 |
|
|
z*******n
发帖数: 1034 | 23 Strong iPhone Sales Pushing 4G LTE Adoption in China
inShare2
May 23, 2014 -- By ChristaH
Strong iPhone Sales Pushing 4G LTE Adoption in China 300x235 Strong iPhone
Sales Pushing 4G LTE Adoption in ChinaChina Mobile, which remains the world
’s biggest mobile carrier with its 788 million subscribers, will likely
send a thank-you note to Apple in the very near future.
According to published reports out of Asia ahead of the weekend, strong
iPhone sales are mostly responsible for accelerating 4G LTE... 阅读全帖 |
|
z*******n
发帖数: 1034 | 24 July 10, 2014 10:45 AM
Richard Byrne Reilly
The Feds are going after Amazon.
The Federal Trade Commission said Thursday morning that the online retail
kingpin unlawfully billed parents for millions of dollars in unauthorized
app purchases made by children. And now the feds want Amazon to return the
money.
The FTC filed suit in federal court this morning, alleging that no parental
consent or passwords were required for kids to buy apps from Amazon’s app
store. That’s a violation of federal law. D... 阅读全帖 |
|
z*******n
发帖数: 1034 | 25 Posted 3 hours ago by Jonathan Shieber (@jshieber)
Online personal and professional continuing education company lynda.com has
raised $186 million at a roughly $1 billion valuation to go shopping for
education technology companies.
It’s the second mammoth round for Lynda, following a $100 million initial
investment from Accel Partners, Spectrum Equity and Meritech. The new round
was led by TPG, a private equity firm with some $65 billion worth of assets
under management.
For lynda.com, the new r... 阅读全帖 |
|
|
w*******y
发帖数: 60932 | 27 If you are the type of person that has an emergency kit tucked away in your
closet then you will love this product. Sawyer is a company that develops
water filtration systems for poor countries and regions and they have been
very successful at it. Their purpose was to lower the cost of filtered water
so that it was affordable to poor villages etc.
They have now branched out to consumer sales over the last few years and
they offer some really awesome prices considering most companies charge a
few... 阅读全帖 |
|
w*******y
发帖数: 60932 | 28 Link:
http://www.pepboys.com/featured_products/free_peak_candlepower_
Free Peak 1 Million Candlepower Spotlight After $10 Manufacturer Mail-In
Rebate
1 Million Candle Power
Locking trigger switch for ease of use
Rubber pistol grip handle for comfort and control
3.5" diameter reflector
Limit 2 per household
It's actually $3 give or take tax after rebate.
|
|
N***i
发帖数: 2063 | 29 【 以下文字转载自 bluechips 俱乐部 】
发信人: liliwater (lyrist), 信区: bluechips
标 题: Netflix Announces New $300 Million Stk Buyback
发信站: BBS 未名空间站 (Sat Jun 12 00:17:55 2010, 美东)
Netflix (NFLX) today said its board has authorized a new plan to repurchase
up to $300 million of its common stock through the end of 2012. This is in
addition to the company’s last authorization in August 2009.
NFLX is up $1.64, or 1.4%, to $120.30. |
|
p*****0
发帖数: 3104 | 30 For this fishing team, $1-million prize is the one that got away
By: Pete Thomas, GrindTV.com
If a person gets caught fishing without a license, in most cases, it results
in a fine of perhaps a few hundred dollars.
For those aboard Citation, however, the infraction represents a setback of
nearly $1 million.
The vessel's anglers had been participating in the 52nd annual Big Rock Blue
Marlin Tournament, June 11-19 off North Carolina. Andy Thomossan landed
what was by far the biggest fish: an 883-p... 阅读全帖 |
|
m****g
发帖数: 530 | 31 Pan-Massachusetts Challenge gives $30.4 million to the Jimmy Fund
Gift brings 30-year total contribution to $270 million
The 2009 Pan-Massachusetts Challenge (PMC) has contributed $30,384,200 to
adult and pediatric cancer
research and care at Dana-Farber Cancer Institute through its August cycling
event.
This PMC fundraising gift is the single largest contribution made to the
Jimmy Fund in 2009, representing 50
percent of the charity's annual revenue. The funds raised by the 4,937
cyclists of th |
|
m****g
发帖数: 530 | 32 ury Awards Ex-Pfizer Scientist $1.37 million: Biotech safety verdict is
hailed as a milestone; company
weighs options [The Day, New London, Conn.]
From Day, The (New London, CT) (April 2, 2010)
Apr. 2--Becky McClain, a Deep River scientist who claims to have been
infected by an experimental virus
while working at Pfizer Inc.’s Groton laboratories, was awarded $1.37
million Thursday by a U.S. District
Court jury in Hartford that found the company had retaliated against her and
interfered with the |
|
S********S
发帖数: 486 | 33 http://www.techcrunch.com/2009/10/26/social-games-how-the-big-three-make-
millions/
So much for the first generation of big Facebook/MySpace social application
startups. Slide and RockYou both got huge valuations in venture rounds. But
a new generation of application developers has taken center stage and are
racking up big revenues and their own eye popping valuations: Zynga,
Playfish and Playdom.
All three own popular social games on Facebook and MySpace. Zynga’s
Farmville has 61 million monthl |
|
K*Q
发帖数: 1001 | 34 Lucid Imagination, the startup that commercially distributes the open source
Apache Lucene and Apache Solr search technology, has raised $10 million in
Series B funding from Shasta Ventures with Granite Ventures and Walden
International participating in the round. This brings the company’s total
funding to $16 million.
Lucid powers enterprise search technologies using the open source Lucene/
Solr search. Customers include Zappos, Nike and Netflix. The new funding
will be used to accelerate the a |
|
|
a******s
发帖数: 2145 | 36 Katie Melua -nine million bicycles in Beijing
There are nine million bicycles in Beijing
That's a fact,
It's a thing we can't deny
Like the fact that I will love you till I die.
We are twelve billion light years from the edge,
That's a guess,
No-one can ever say it's true
But I know that I will always be with you.
I'm warmed by the fire of your love everyday
So don't call me a liar,
Just believe everything that I say
There are six BILLION people in the world
More or less
and it makes me feel qu |
|
s***a
发帖数: 4921 | 37 (CNN) -- A Cape May, N.J., couple -- Sandra and John Belawsky -- was
introduced to reporters Friday as one of four winners of a $330 million Mega
Millions jackpot.
The couple came forward Tuesday with the winning ticket, but lottery
officials delayed a press conference until Friday afternoon in Trenton. They
will be awarded $48,615,187 before 25 percent federal income taxes. After
taxes, their take is $36,461,390, officials said. They do not have to pay
state income taxes.
"Were stunned. We stil |
|
s******o
发帖数: 298 | 38 By Tariq Malik
Staff Writer
posted: 07:00 am ET
03 July 2002
The mantra 'bigger is better' is popular among astronomers, who develop ever-
larger telescopes for a better view of the universe. But in Canada, where
researchers are building the smallest space telescope ever, the saying bears
no weight.
The Canadian Space Agency (CSA) plans to put its first space telescope in
orbit inside a package no bigger than a suitcase. At $10 million in Canadian
terms (about $6 million in U.S. currency), the m |
|
W*****e
发帖数: 7759 | 39 【 以下文字转载自 SanFrancisco 讨论区 】
发信人: Warfare (German==Arschloch), 信区: SanFrancisco
标 题: Jaycee Lee Dugard to receive $20 million from California
发信站: BBS 未名空间站 (Fri Jul 2 10:03:27 2010, 美东)
Miss Dugard, 30, resurfaced last August having given birth to two daughters
by convicted rapist Phillip Garrido.
She and her daughters, who are 15 and 12, filed claims for psychological,
physical and emotional damages in February against the state's Department of
Corrections and Rehabilitation, which they said |
|
s***5
发帖数: 453 | 40 http://www.washingtonpost.com/wp-dyn/content/article/2010/08/11/AR2010081105602.html
The rescue effort represents the most visible element of a broader, $55
million U.S. assistance package following Pakistan's worst-ever natural
disaster. While the ultimate impact on Pakistani public opinion is unknown,
the United States has earned rare and almost universal praise here for
acting quickly to speed aid to those hit hardest.
tu gong yao jia you a!! |
|
|
|
