Please, sorry for a delayed reply. In my previous mail I've asked
you include the output of 'show variables' statement, so please
do it in your next message. I'd like (and probably others on
the list) to see your settings. Also, perform the 'show status' just
after t
what does the JDBC code look like that your using to do the inserts?
On Fri, 2005-11-11 at 13:56 -0800, Dhiren Bhatia wrote:
> Any ideas on how I can optimize this? Thanks.
>
> On 11/9/05, Dhiren Bhatia <[EMAIL PROTECTED]> wrote:
> >
> > This is on a development box, 1.5 GB RAM, 1CPU (1.6GHz) wi
Any ideas on how I can optimize this? Thanks.
On 11/9/05, Dhiren Bhatia <[EMAIL PROTECTED]> wrote:
>
> This is on a development box, 1.5 GB RAM, 1CPU (1.6GHz) with the app
> server & database server running on the same box. I'm using the Tomcat
> Database Connection Pool to get a JDBC connection
This is on a development box, 1.5 GB RAM, 1CPU (1.6GHz) with the app server
& database server running on the same box. I'm using the Tomcat Database
Connection Pool to get a JDBC connection and insert the data. I dont have
too much free disk space on this machine (approx 2GB). At the time of the
in
Hello.
As others suggest send the 'CREATE' statement for your table, and,
please, include the output of :
'show status';
'show variables';
> How long should it take to insert approx 30,000 rows into MySQL. It
> takes me
> about 30 mins. I'm using version 4.1.10-nt. Any ideas?
That seems like a long time. Although I don't know how much data you
are importing, how many indexes you have on the database, memory,
etc. How you are going about importing can affect your speed
dramatically. If you are importing a tab delimited (or other
delimination) file, you should get
> How long should it take to insert approx 30,000 rows into MySQL.
Depends on the data and field structure. Do you have lots of indexes
on the table?
>It takes me about 30 mins.
There are some tips at http://dev.mysql.com/doc/refman/4.1/en/insert-speed.html
--
Scott Noyes
[EMAIL PROTECTED]
--
