INSERT Query via CSV taking ages


Jeeebus
HOME ยป 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"); medianet_width='336'; medianet_height= '280'; medianet_crid='202258688';

Related to : INSERT Query via CSV taking ages
INSERT Query via CSV taking ages
by Jeeebus in 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? TAGS: INSERT Query taking ages
Query taking ages :(
by Neuromaster in Databases
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:
TAGS: Query taking ages

Query taking ages for no apparent reason
by showb1z in 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
postgres query with high cpu taking ages to run
by James Dio in 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


Simple insert query taking 1-5 second(s)
by Miklebud in Databases
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:
Query taking long time to insert data in sql server express
by Pseudoics in 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


Taking ages. Why?
by maniacalpha1-1 in Databases
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
TAGS: Taking ages

taking AGES to export swf
by cthulhup in Databases
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
Script taking ages to run
by john3850 in 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
Bluetooth taking ages
by mhedberg in Databases
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
Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2014 © bighow.org All Rights Reserved .