2007/5/16, Franco Guidoli <francoguidoli@hotmail.com>:

Hi all: I'm trying to measure the response time of MonetDB against a
commercial RDBMS, so I've made a dump of the data from my current database
in order to load into MonetDB. I have approximately 2.6 million rows,
divided into 26 flat files of 100k rows each one, which I load using then
SQL command "copy into....". Everything works ok with the data load
(performing a commit after each 100k file), and I can make use of that data
in the same session from which I've loaded the data, but when I restart
MonetDB Server, I can't login via SQL (I can start MonetDB Server, but SQL
Client doesn't respond).

Apparently, from what I can realize, after the shutdown of MonetDB Server,
there is a big log file in Monet's sql_logs directory, and when I get a
response from SQL Client, the log file is apparently empty (I've realized
this loading only 200k rows).

Is this the expected behaviour for the MonetDB SQL Server? Did I miss
anything in order to avoid this? After the second start of the server, this
doesn't happen anymore until I load new data.

I'm working with MonetDB Server v5.0.0_beta1_2 (downloaded msi from
sourceforge) over Windows XP, and the SQL Client is via JDBC.

Thanks in advance for any help you can give me.

Franco
--
View this message in context: http://www.nabble.com/Not-responding-after-sql-server-restart-tf3762198.html#a10634608
Sent from the monetdb-users mailing list archive at Nabble.com.

-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
_______________________________________________
MonetDB-users mailing list
MonetDB-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/monetdb-users