On 09-06-2008 23:10:41 -0700, Rt Ibmer wrote:
> Short of increasing/changing my hardware or changing my code around to bulk
> write inserts (which I assume would help?) is there anything I can do to
> improve the speed at which MonetDB can insert records into the db?
Batching on a PreparedStatem
I have a Java app that needs to write single inserts into the db in an
extremely fast manner (it is receiving data in real time, and buffering it,
then doing single inserts to feed the data into the db as fast as it will
insert it). I am doing this using JDBC and this resides on the same physic
Dear MonetDB developer and users,
For convenience of both developers and users as well as to comply even more
with open source standards, we now set/use the following defaults for the
configure options
--enable-strict, --enable-assert, --enable-debug, --enable-optimize
(Unless specified dif
On 09-06-2008 18:32:47 +0200, Romulo Goncalves wrote:
> I removed all the dbfarm, sql_logs and all the lib_* files
> Clean installation and I continue to get:
>
> E:\MonetDB\Current\sql\NT>RunMserver5.bat
> !WARNING: GDKlockHome: created directory
> E:\MonetDB\Current\\sql\NT\dbfarm\demo\
> !
I removed all the dbfarm, sql_logs and all the lib_* files
Clean installation and I continue to get:
E:\MonetDB\Current\sql\NT>RunMserver5.bat
!WARNING: GDKlockHome: created directory
E:\MonetDB\Current\\sql\NT\dbfarm\demo\
!WARNING: GDKlockHome: ignoring empty or invalid .gdk_lock.
!WARNING:
> Hi - I have an int column with several million rows of data. What is the
> fastest way to write a query to get the median value of the column?
> Apparently there is no median() function in SQL. A web search revealed lots
> of various talk about using stored procedures and fancy functions.
On Sun, Jun 08, 2008 at 08:43:24AM +0200, Martin Kersten wrote:
A fix for this bug was checked into the stable branch.
Niels
> Rt Ibmer wrote:
> > I was going crazy trying to figure out why my COPY RECORDS command wasn't
> > working. Turns out it is caused from funny (encoded?) characters in t
