|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?
|Query taking ages :(|
| by Neuromaster in Databases|
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.
|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
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
|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
|Simple insert query taking 1-5 second(s)|
| by Miklebud in Databases|
Can anyone lighten me up why this simple query is taking so
The table has very few rows (like 500-700) and only 3
Column name: user
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|
I am trying to produce a report based on a crosstab
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
|Hawkhost taking ages|
| by dlock13 in Databases|
I'm not sure what's going on at Hawkhost but it's taking ages for
them to setup my webhost account.
Normally when I purchase a
webhost it's instantly set up or takes a few hours.
Right now it
has been 18 hours since I have purchased the service.
having the same experie
|taking AGES to export swf|
| by cthulhup in Databases|
taking AGES to export swf
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
*,concat('[',first,'][',last,'][',postcode,']') from `new` where