Please enable / Bitte aktiviere JavaScript!
Veuillez activer / Por favor activa el Javascript![ ? ]
How to work with the database dbf 370 Mb? - bug-code.com Q&A

How to work with the database dbf 370 Mb?

0 like 0 dislike
11 views
The first time I faced such a problem. There is a database in a text file 370 Mb.
It has fields field1, field2,field3 and field2 can be repeated up to a hundred times, and field1 and field3 is unique. The task is to pull unique data array $field 2 all records from the database. Ie get 180,000 rows with the merged data, field1, field3. Now in database 3280000 lines. The algorithm I built, but due to the fact that every time they have fully wool base, the sampling occurs at a rate of 3000-4000 lines per day. The problem is that just a sample of the case is complete and every row need to process using PHP. How to speed up?
asked by | 11 views

2 Answers

0 like 0 dislike
pound data in mysql/postgres/etc and drive their selection.
answered by
0 like 0 dislike
sampling occurs at a rate of 3000-4000 lines per day

You did something very wrong. 3 million rows and 400 MB are loaded almost entirely in the operative and there carstats fast enough.
answered by
Welcome to Bug-code Q&A, where you can ask questions and receive answers from other members of the community.

24.8k questions

46.2k answers

0 comments

13.3k users

24,788 questions
46,220 answers
0 comments
13,321 users