0
votes
0answers
70 views

Can I use MySql for storing 1000 rows per second? [closed]

The database have only two fields: key, value. The client send me just a key. The server check, if the key exists in the database, it increment it value (+1). If the key is not exists in the ...
0
votes
4answers
968 views

How to insert/update a large amount of data into mysql using php

I have an excel sheet which has a large amount of data. I am using php to insert the data into mysql server. I have two problems 1) I have to update a row if the id already exists, else insert the ...
0
votes
0answers
84 views

Searching in a large dataset

I am working on a model of social interactions in mice. I have mice and boxes and a simulation that outputs which mouse stays in which box during which time period. The problem is how to obtain, in ...
1
vote
2answers
145 views

Using replacement to get possible outcomes to then search through HUGE amount of data

I have a database table holding 40 million records (table A). Each record has a string a user can search for. I also have a table with a list of character replacements (table B) i.e. i = Y, I = 1 ...