Questions tagged [large-data-volumes]

302 questions
0
votes
0 answers

Amazon EC2 Force umount Volume does not work

I am trying to detach an Amazon EC2 Volume, but It get stuck some where, here is the strace output, I tried fuser -km /mnt/web but none of the option is working. I also tried ls /mnt/, and deleted the entry from /etc/fstab but it still won't…
Aftab Naveed
  • 3,652
  • 3
  • 26
  • 40
0
votes
0 answers

node.js express.js app not working for large traffic (600/min)

I am working on node.js express.js app which is used for user data collection (in get request) and sends back only 200 ok response. After getting data in request I am checking for existing entry in database dynamodb and redshift and for newer…
0
votes
1 answer

MySQL: How to handle regular high volume of inserts/updates?

I have table where I track various statistics about site usage. Once a week, I plan to use these statistics and information from other tables to calculate various key indicators for use in multiple reports. This is in order not to have compute the…
Tom
  • 30,090
  • 27
  • 90
  • 124
0
votes
0 answers

Sql Server large data

I have sql server 2012 installed on a Virtual machine. With quad core processor (2.0 GHz) and 32 GB RAM. The Data volume is about 400 GB and there is a Table with 824 million records in it. The Records are date wise. I have to pull data from…
0
votes
1 answer

Pythonic way to process 200 million element data set?

I have a directory of 1,000 files. Each file has many lines where each line is an ngram varying from 4 - 8 bytes. I'm trying to parse all files to get the distinct ngrams as a header row, then for each file, I want to write a row that has the…
0
votes
1 answer

Updating large volume of records

I have a table having more than 10 mil records and I have to update multiple columns of this table from the data which I get from few other tables which again have large number of records. All the tables are indexed I tried doing it in batches and…
0
votes
3 answers

Theoretical large volume issue, can't use collection to sort in .NET

Excuse the title of this post, but I can't really think of a more creative title. I am calling a 3rd party web service where the authors are ordering transaction results from most recent. The total transaction count is greater than 100 000. To make…
JL.
  • 78,954
  • 126
  • 311
  • 459
0
votes
2 answers

Algorithm for calculate all difference values from a large list

​I have a question that now I have a list of 3 million records and I want get all difference values between every two records. A simple nested loop may take forever. Could anyone suggest me any algorithm which is capable of handling this problem?
0
votes
1 answer

MySql search efficiency

So I am trying to get some geographical data at the moment from the some 34 thousand records we have. We stored a records of Person, which include the basics like firstname, surname, address and postcode. I am wanting to get information about the…
Lars
  • 59
  • 1
  • 2
  • 8
0
votes
1 answer

Matrix calculation gets slower after each iteration in matlab

I have a 1024*1024*51 matrix. I'll do calculations to change some value of the matrix within for loops (change the value of matrix for each iteration). I find that the computing speed gets slower and slower and finally my computer gets into…
lee891031
  • 1
  • 2
0
votes
2 answers

Improving select speed - mysql - very large tables

Newbie to MySQL and SQL in general - so please be gentle :-) I have a table with a very high number of rows. The table is: create table iostat ( pkey int not null auto_increment, serverid int not null, datestr char(15) default 'NULL', esttime …
opsdog
  • 13
  • 4
0
votes
1 answer

Command line script or software tools to label 3d point cloud dataset

How can i label a 3d point cloud dataset? is there a software which can load a text file containing x,y,z values and then visualize it , so that I can label it ?
0
votes
1 answer

Display ALL countries in an autocomplete form

First time posting on here because Google is yielding no results! So, I have a website that is based around travelling and locations. Everytime someone enters content into the site, they select a location and that content then has lat and long,…
0
votes
1 answer

Statistics on large table presented on the web

We have a large table of data with about 30 000 0000 rows and growing each day currently at 100 000 rows a day and that number will increase over time. Today we generate different reports directly from the database (MS-SQL 2012) and do a lot of…
Addeladde
  • 777
  • 2
  • 9
  • 28
0
votes
2 answers

Search a large amount of data in DynamoDB

I have a use case, in which my data is stored in DynamoDB with hashkey as UniqueID and range key as Date. The same data is also present in simple storage service of Amazon(S3). I want to search all the data based on time range. I want this to be…