I should say that running 7 quueries against 200MB table with ~600 000 rows
for 4 seconds looks to me as if there was no indexes and very poor database
design (i mean that CVS file is dumped into database incorrectly). Or you'r
server is Pentium 100 :)
P.S. Having myself a 1.5GB database with
Wolf wrote:
Danny Brow wrote:
I have about 10 csv files I need to open to access data. It takes a lot
of time to search each file for the values I need. Would it be best to
just dump all the cvs files to an SQL db and then just grab what I need
from there? I'm starting to think it would make a
I have about 10 csv files I need to open to access data. It takes a lot
of time to search each file for the values I need. Would it be best to
just dump all the cvs files to an SQL db and then just grab what I need
from there? I'm starting to think it would make a lot of sense. What do
you guys
cumbersome to search.
You could try out a few scenarios and see how they work speed-wise and impact
on system memory and such.
-TG
- Original Message -
From: Danny Brow [EMAIL PROTECTED]
To: PHP php-general@lists.php.net
Date: Mon, 10 Mar 2008 21:09:15 -0400
Subject: [PHP] CSV speed
I have
Danny Brow wrote:
I have about 10 csv files I need to open to access data. It takes a lot
of time to search each file for the values I need. Would it be best to
just dump all the cvs files to an SQL db and then just grab what I need
from there? I'm starting to think it would make a lot of sense.
On Mon, 2008-03-10 at 22:36 -0400, Wolf wrote:
Danny Brow wrote:
I have about 10 csv files I need to open to access data. It takes a lot
of time to search each file for the values I need. Would it be best to
just dump all the cvs files to an SQL db and then just grab what I need
from
to search.
You could try out a few scenarios and see how they work speed-wise and
impact on system memory and such.
-TG
- Original Message -
From: Danny Brow [EMAIL PROTECTED]
To: PHP php-general@lists.php.net
Date: Mon, 10 Mar 2008 21:09:15 -0400
Subject: [PHP] CSV speed
I have about
On Mon, Mar 10, 2008 at 8:09 PM, Danny Brow [EMAIL PROTECTED] wrote:
I have about 10 csv files I need to open to access data. It takes a lot
of time to search each file for the values I need. Would it be best to
just dump all the cvs files to an SQL db and then just grab what I need
from
Danny Brow wrote:
On Mon, 2008-03-10 at 22:36 -0400, Wolf wrote:
Danny Brow wrote:
I have about 10 csv files I need to open to access data. It takes a lot
of time to search each file for the values I need. Would it be best to
just dump all the cvs files to an SQL db and then just grab what I
Greg Donald wrote:
On Mon, Mar 10, 2008 at 8:09 PM, Danny Brow [EMAIL PROTECTED] wrote:
I have about 10 csv files I need to open to access data. It takes a lot
of time to search each file for the values I need. Would it be best to
just dump all the cvs files to an SQL db and then just grab
10 matches
Mail list logo