Search:

Type: Posts; User: bballard

Page 1 of 4 1 2 3 4

Search: Search took 0.00 seconds.

  1. Replies
    2
    Views
    71

    Hello Snowball, Stored procedures are...

    Hello Snowball,

    Stored procedures are pre-compiled and the queries within them are pre-planned, whereas Ad Hoc SQL statements must be parsed and planned on the fly which adds overhead to each...
  2. One other thing to be careful of is to either run...

    One other thing to be careful of is to either run the instances in separate directories and use the default voltdbroot subfolder, or configure the paths in the deployment.xml file to output to...
  3. I put up an example in a branch of one of our...

    I put up an example in a branch of one of our demos: https://github.com/VoltDB/app-nbbo/tree/playback

    Here is the example java client:...
  4. Replies
    3
    Views
    265

    Hi Arthur, I may have misunderstood your...

    Hi Arthur,

    I may have misunderstood your question. I posted this on Stack Overflow as well:

    Data stored in VoltDB (e.g. when you insert records) is stored 100% in RAM and is not compressed....
  5. Replies
    3
    Views
    265

    Hi Arthur, VoltDB uses the Snappy compression...

    Hi Arthur,

    VoltDB uses the Snappy compression algorithm for writing snapshots to disk. Snappy is optimized for speed vs. compression ratio, but the compression is still pretty good. There aren't...
  6. Hi Pavangadiya, Why not do the mathematical...

    Hi Pavangadiya,

    Why not do the mathematical comparison of columns within a query on the database itself? Also, after this comparison is done, what happens with the results, do you need to do...
  7. Hi Pavagadiya, The basic way to iterate with...

    Hi Pavagadiya,

    The basic way to iterate with OFFSET and LIMIT is to increment the OFFSET by the amount of the LIMIT. For example:
    int recordcount;
    //query the count(*) of the table first to get...
  8. Replies
    2
    Views
    87

    Hi Alessandro, Here is the documentation for...

    Hi Alessandro,

    Here is the documentation for the supported DDL statements and their syntax: http://docs.voltdb.com/UsingVoltDB/AppxDDL.php

    The CREATE TABLE statement doesn't support the syntax...
  9. Replies
    1
    Views
    102

    Hi Yiannis, Supposing the query is a GROUP BY...

    Hi Yiannis,

    Supposing the query is a GROUP BY query, and you want to aggregate at regular intervals, you can use a VIEW to make this very efficient. Any regular interval can be made by leveraging...
  10. Replies
    5
    Views
    2,511

    VoltDB uses the TIMESTAMP datatype, which...

    VoltDB uses the TIMESTAMP datatype, which includes date and time. You can insert a date string in the format 'YYYY-MM-DD' into a timestamp datatype column and it will default the time to 00:00:00. ...
  11. Replies
    2
    Views
    195

    In general, this is not recommended for a few...

    In general, this is not recommended for a few reasons:
    - It could cause issues with determinism
    - i/o will slow the execution of the procedure

    It would be better to use export. You could...
  12. Can you provide the rest of the SQL statement? ...

    Can you provide the rest of the SQL statement? Line number 15 is just the line that begins the statement, but the error could be anywhere in the statement.
  13. Hi Arthur, We'd love to help you with a POC. ...

    Hi Arthur,

    We'd love to help you with a POC. This is a question that might be best handled with a discussion. Could you contact me directly to set up a call to go over this.

    I will try to...
  14. Hi Edson, Thanks, we're interested in your...

    Hi Edson,

    Thanks, we're interested in your results. Please ask us to review your tests further if you get lower than expected performance. We're happy to take the conversation private if you...
  15. Hi Edson, It looks like your Test.java class...

    Hi Edson,

    It looks like your Test.java class creates a new client object, connects to one node of VoltDB, calls a single procedure using a synchronous call, then closes the connection.

    VoltDB...
  16. No, you don't need to call drain() before sending...

    No, you don't need to call drain() before sending more requests. In our example applications, drain() is called at the end of the run to ensure that all the responses are received before the...
  17. Hi Stijn, Stefano will assist you. I was...

    Hi Stijn,

    Stefano will assist you. I was typing this earlier and got interrupted, but it may still be useful.

    There isn't a way to call one stored procedure from another. If the work can be...
  18. Replies
    3
    Views
    709

    HD.Users.Boss.voltdb-4.2.voltdb may be a java...

    HD.Users.Boss.voltdb-4.2.voltdb may be a java package name that is somehow inadvertently generated from your directory structure /HD/Users/Boss/voltdb-4.2/voltdb

    It doesn't make sense that this...
  19. Hi Kadafi, You can follow the instructions...

    Hi Kadafi,

    You can follow the instructions linked above to install the tar.gz distribution of VoltDB Enterprise Edition, which includes a 30-day trial license. You can download the precompiled...
  20. Replies
    13
    Views
    2,429

    Hi Derek, This seems like a lot of boilerplate...

    Hi Derek,

    This seems like a lot of boilerplate java code to queue and execute 2 SQL statements, but I assume you have your reasons for that. I don't see any reason why it wouldn't work correctly...
  21. Hi Sabrina, We recommend setting sitesperhost...

    Hi Sabrina,

    We recommend setting sitesperhost to somewhere between 1/2 to 3/4 of the total number of cores (counting 2x for CPUs with hyperthreading), but it's always good to experiment to see...
  22. Hi Sabrina, There is an explanation of...

    Hi Sabrina,

    There is an explanation of Synchronous vs. Asynchronous procedure calls in the Performance Guide here: https://voltdb.com/docs/PerfGuide/Hello2Async.php

    Take a look especially at...
  23. Replies
    13
    Views
    2,429

    Hi Paul, I tried some variations and found a...

    Hi Paul,

    I tried some variations and found a few things. I'm going to revise what I wrote above on 3/21 about there being two ways to reuse SQLStmt objects, there is really only one way that...
  24. Replies
    13
    Views
    2,429

    I'm able to reproduce this. I'll get back to you...

    I'm able to reproduce this. I'll get back to you later today.
  25. Replies
    13
    Views
    2,429

    Hi Paul, The VoltProcedure.voltQueueSQL()...

    Hi Paul,

    The VoltProcedure.voltQueueSQL() method is an object method, not static, so when it is called within a normal stored procedure, it is equivalent to "this.voltQueueSQL(...);". From the...
Results 1 to 25 of 92
Page 1 of 4 1 2 3 4