INSERT Query via CSV taking ages



Category : Databases
I am trying to upload a 350,000 line CSV file.
Each row is checking that it doesn't exist already (to avoid duplicates), and then remove the " at the end of the run.
I thought it would take maybe a minute or two. It's taking a lot longer. Is my script badly done, causing it to be slow?
Syntax: [ Download ] [ Hide ]SXBB[id].writeCmd();Syntax: [ Download ] [ Show ]if ($update == "addcsv")
{
if ($_FILES[csv][size] > 0)
{
    //get the csv file
    $file = $_FILES[csv][tmp_name];
    $handle = fopen($file,"r");
View Replies

Related to : INSERT Query via CSV taking ages


Query taking ages :(
Category : Development
Hi,
I have this query in a script which checks expiring orders, changes their status and sends out email reminders and runs in about 3 or 4 secs. Cool.
PHP Code:

View Replies

TAGS: Query taking ages

Query taking ages for no apparent reason
Category : Databases
Query taking ages for no apparent reason
 
Hope someone can help me with this because its driving me potty!
I have a .NET script that sends really simple queries to SQL server that works perfectly 50% of the time but for the other 50% it takes ages (2-3 minutes) and the

View Replies


postgres query with high cpu taking ages to run
Category : Databases

I have a web application that runs off PHP and a postgres backend (9.1).


Most of the heavy DB lifting work is done via postgres stored procedures.


One of the processes in the app is an import data routine. The stored procedure is quite intensive on import but whilst develo


View Replies


Simple insert query taking 1-5 second(s)
Category : Development
Hi,
Can anyone lighten me up why this simple query is taking so much time?
The table has very few rows (like 500-700) and only 3 columns.
Table properties:
Index:
keyname: user
BTREE
Column name: user
_______
Query:
Query_time: 2.008483 Lock_time:

View Replies


Taking ages. Why?
Category : Access
Dear All
I am trying to produce a report based on a crosstab query.
In the crosstab query I have take a date field as column heading with the format "yyyymm" and couple of fields as row headings. Crosstab query is further based on a select query that has a criteria defined

View Replies

TAGS: Taking ages

Query taking long time to insert data in sql server express
Category : Databases

I have strange scenario in which if I create database using SQL Server 2008 Express (database compatibility level SQL Server 2008) and perform insert using xml datatype, it executes indefinitely, but when same query is executed on database with compatibility level SQL Server 2005 it runs fine an


View Replies


taking AGES to export swf
Category : Design Software
taking AGES to export swf
 
Hi
I am currently doing a project in flash for college. My problem that despite the fact that my .fla is only 128KB , everytime I try to test the movie its taking nearly 90 seconds to export. Does anyone know why this might be happening and i

View Replies


desktop,taking ages ??
Category : Information Security
desktop,taking ages ??
  can anybody help with the above, had a look in startup and its all alien to me as i thought that might be the problem ,deleted all temp internet files cookies etc,defragmented, ran all antivirus,internet security and nothing to report, so iam thinking it could be al

View Replies


Script taking ages to run
Category : Databases

Hi all wonder if you can help me below is the script i run

Code:

select *,concat('[',first,'][',last,'][',postcode,']') from `new` where concat('[',first,'][',last,'][',postco

View Replies


Bluetooth taking ages
Category : Windows XP & 7 & 8
Hi, I'm trying to download the Toshiba bluetooth as I have fitted a Toshiba internal bluetooth module to my p200-1ee but when it's installing this is what happens and doesn't move
Any ideas to this problem.
Scotty

View Replies


2012 / 2017 Copyrights BigHow , All Rights Reserved .