May 2008 - users-list

[MonetDB-users] How could I run a set of XQuery in a batch?
by Chinyi Woo 14 May '08

14 May '08

Hello, everyone May I ask you how to run a set of XQueries in a batch? I am using MonetDB v4.22.0 on Redhat Linux. I have a set of XQueries. I want to run them against a single xml document and collect the running time. Currently I am only able to submit one XQuery at a time at the mclient commandline. Is there anyway for me to send all my XQueries in a batch and get the total running time? I also have another question. Does MonetDB handle multi-query optimization? I mean if more than one … [View More]

2 1

[MonetDB-users] A sanity check on MondetDB/XQuery performance
by Nils Grimsmo 13 May '08

13 May '08

Using the "super-ball" from February. I am running some queries, and just want to check if my performance is sane. Are there more indexes I can ask to get built to increase performance? I don't ask for an accurate verification, just a hint of whether or not we are within an order of magnitude of what seems right :) $ Mserver --dbinit="module(pathfinder);" --set mapi_port=60000 $ echo 'pf:add-doc("path/dblp.xml", "dblp.xml")' | mclient --lx -p60000 --time Timer 73068.138 msec $ echo … [View More]

3 3

[MonetDB-users] mclient command line history question
by Drew Sky 12 May '08

12 May '08

Hello, I am having trouble using the command line history feature of mclient. After I run a query at the command line, I can't re-use the same query by pressing the up-arrow. From documentation, it seems like I should be able to do this. Is this a feature I should have compiled in, when building from source code? When I press the up-arrow after a query I get sql>^[[A I've tried adding the --history and --interactive options but it doesn't help. I've also tried changing the … [View More]

2 1

[MonetDB-users] php5 and windows
by Michiel Kamermans 08 May '08

08 May '08

Hi all, I've been hearing interesting things about MonetDB so I figured I'd see how it performed with the data that my website uses (several million cross-referencing records of Japanese/English dictionary data) by installing it for use with PHP5... but I ran into a problem come actual PHP interfacing. Which steps must be taken to get PHP5 to properly interface with MonetDB on a windows machine? The online documentation (http://homepages.cwi.nl/~mk/MonetDB/The-PHP-Library.html) has a … [View More]

1 0

[MonetDB-users] Limit statements
by Henrik Vendelbo 07 May '08

07 May '08

The section on sorting and limit 3.1.7.2 Select lists, distinct, sorting, limit Is very brief and doesn't seem to describe limit/sort, does this mean that LIMIT/OFFSET is supported or that ROW_NUMBER should be used? Henrik

2 1

[MonetDB-users] MonetDB/XQuery not coming back
by Richard Eckart 06 May '08

06 May '08

Hi there, I am looking again into MonetDB/XQuery. A colleague of mine ran a little test on MonetDB/XQuery and made the experience that when starting the server and importing some documents, a query is possible. But when killing the server (running as deamon - killed with CTRL-C), restarting it the same query never comes back. He tried this under FreeBSD and I am experiencing the same problem now on Mac OS X 10.4.11. I turned on debug logging (level 255) but did not see anything that … [View More]

1 0

[MonetDB-users] Tutorial for database scripting language MIL?
by jz＠uva 06 May '08

06 May '08

Hi all, Does someone have a tutorial for the database scripting language MIL? I am currently checking pftijah.mx, but I am wondering whether there is a better option than trying to reverse engineer things. Thanks, junte

3 2

[MonetDB-users] MySQLError ?
by Henrik Vendelbo 06 May '08

06 May '08

I was having a look at the __init__.py module header for MonetSQLdb, and saw the following: __all__ = [ 'BINARY', 'Binary', 'Connect', 'Connection', 'DATE', 'Date', 'Time', 'Timestamp', 'DateFromTicks', 'TimeFromTicks', 'TimestampFromTicks', 'DataError', 'DatabaseError', 'Error', 'FIELD_TYPE', 'IntegrityError', 'InterfaceError', 'InternalError', 'MySQLError', 'NULL', 'NUMBER', 'NotSupportedError', 'DBAPISet', What is the reference to MySQLError doing in the code? I suppose it … [View More]

2 1

[MonetDB-users] Fwd: [ monetdb-Bugs-1957794 ] How to debug on Windows OS?
by Lefteris 05 May '08

05 May '08

Please read carefully the following comments to avoid opening a third bug with the same question. thank you ---------- Forwarded message ---------- From: SourceForge.net <noreply(a)sourceforge.net> Date: Mon, May 5, 2008 at 10:30 AM Subject: [ monetdb-Bugs-1957794 ] How to debug on Windows OS? To: noreply(a)sourceforge.net Bugs item #1957794, was opened at 2008-05-05 09:50 Message generated for change (Comment added) made by lsidir You can respond by visiting: https://sourceforge.… [View More]

1 0

[MonetDB-users] Django Backend: SQL column types
by Henrik Vendelbo 04 May '08

04 May '08

Hi guys, I am jumping straight into the deep end with Monet. My first task is to implement a backend for Django written in Django. I need to map the field types to SQL column types, and that is for the most part easy, yet a few questions: 1) Is 'integer' accepted, or do I have to use 'int' 2) How do I specify a floating point with specified max_digits and decimal_places? I didn't see support for numeric in the docs. 3) How do I specify unsigned integers? unsigned or check expression? Is … [View More]

3 2