Search:

Type: Posts; User: bballard

Page 1 of 3 1 2 3

Search: Search took 0.00 seconds.

  1. 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...
  2. 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...
  3. Replies
    10
    Views
    527

    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...
  4. Replies
    10
    Views
    527

    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.
  5. Replies
    10
    Views
    527

    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...
  6. Replies
    10
    Views
    527

    Hi Paul, Thanks for bringing this to our...

    Hi Paul,

    Thanks for bringing this to our attention. Can you use a broader wildcard as a workaround? I'll have our engineering team review this as a potential bug in the wildcard matcher.
    ...
  7. Replies
    10
    Views
    527

    Thanks for sharing that link, Paul. That is from...

    Thanks for sharing that link, Paul. That is from a while ago when we did not have some features such as the IMPORT CLASS statement, and the only way to make java code that was outside of a stored...
  8. Replies
    5
    Views
    292

    Hi FloM, Yes, this can also work with the...

    Hi FloM,

    Yes, this can also work with the Python client. If you refer to the Python Client README file, it mentions that parameters can be arrays (or lists). You declare the VoltProcedure...
  9. Replies
    10
    Views
    527

    Hi Paul, There are two ways you can re-use...

    Hi Paul,

    There are two ways you can re-use SQLStmt objects.

    One is you can have a "Base" Stored Procedure that extends VoltProcedure and defines a number of reusable SQLStmt objects, and then...
  10. Replies
    5
    Views
    292

    There are some notes about using "WHERE column IN...

    There are some notes about using "WHERE column IN ?;" syntax in Using VoltDB, App. B - SELECT (https://voltdb.com/docs/UsingVoltDB/sqlref_select.php) about halfway down the page.

    For example, if...
  11. Replies
    2
    Views
    194

    Hi Martin, The interface between a stored...

    Hi Martin,

    The interface between a stored procedure (running in java) and the SQL Execution Engine (running in C++) is when you call voltExecuteSQL(). At that point, the queued statements and...
  12. Replies
    2
    Views
    517

    Thanks for the files. For the benefit of forum...

    Thanks for the files. For the benefit of forum readers, here is a summary of the issue.

    When security is enabled, VEM should automatically choose a user from the xml file that it will use itself...
  13. Replies
    2
    Views
    517

    Hi, There is no configuration to indicate to...

    Hi,

    There is no configuration to indicate to VEM which user account to use, but it should choose one of the users in the file that has sufficient privileges. I'd like to try to reproduce the...
  14. VoltDB 4.0 requires Sun or Open JDK version 7. ...

    VoltDB 4.0 requires Sun or Open JDK version 7. You will need to install JDK 7, then recompile stored procedure java classes and the catalog.
  15. Replies
    2
    Views
    552

    Hi Louis, In VoltDB 3.7, you need to include...

    Hi Louis,

    In VoltDB 3.7, you need to include the guava-12.0.jar file in your CLASSPATH for java clients using either the native java client library or the JDBC driver. The file is provided in the...
  16. Hi Kamal, You can declare multiple CREATE...

    Hi Kamal,

    You can declare multiple CREATE TABLE statements in one DDL .sql file. Typically a simple schema will be in one file, but you can use multiple files as in the examples here:...
  17. Replies
    2
    Views
    326

    Hi Paul, Typically a TINYINT (1-byte signed...

    Hi Paul,

    Typically a TINYINT (1-byte signed integer) datatype is used, with the convention of 1 for true, 0 for false. While you need to compare it to a constant 1 or 0 in expressions, it has...
  18. Replies
    3
    Views
    1,764

    That is correct. I meant to add earlier that the...

    That is correct. I meant to add earlier that the speed of restoring from disk depends on the data size, disk speed, level of k-safety, and the number of servers in the cluster.

    Just to make sure...
  19. Replies
    3
    Views
    1,764

    The safe process to upgrade VoltDB binaries is to...

    The safe process to upgrade VoltDB binaries is to use a maintenance window and restore from a snapshot.

    This is the same process described here, except during the downtime you would replace the...
  20. Replies
    2
    Views
    2,878

    If you are using the VoltDB java client library,...

    If you are using the VoltDB java client library, you do not necessarily need to use connection pooling. A "Client" object (org.voltdb.client.Client) is thread-safe and can be shared by all of the...
  21. Replies
    6
    Views
    1,264

    The VoltDB compiler doesn't currently support...

    The VoltDB compiler doesn't currently support anonymous inner classes. The anonymous inner class in your code is this:

    new TypeReference<Map<String, String>>() {}

    Note also the Demo$1.class...
  22. Replies
    6
    Views
    1,264

    If you added the 3 jar files to the extension...

    If you added the 3 jar files to the extension folder, you do not need to use the IMPORT statement or set the CLASSPATH, so you could skip the steps you numbered 2 and 3.

    It looks like the error is...
  23. Replies
    6
    Views
    1,264

    To use a third-party library like jackson, the...

    To use a third-party library like jackson, the library needs to be loaded by the database process at runtime. If you only need the two classes TypeReference and ObjectMapper, then you could extract...
  24. You can use STDIN/STDOUT with sqlcmd, so there...

    You can use STDIN/STDOUT with sqlcmd, so there are various command line techniques that can work:

    echo "exec Select 'Spanish';" | sqlcmd --output-format=csv > output.csv

    sqlcmd...
  25. Quick correction: If you omit the "--classpath...

    Quick correction:
    If you omit the "--classpath <directory>" parameter from the "voltdb compile" command, it does not default to the current directory. Omitting this parameter only works when your...
Results 1 to 25 of 72
Page 1 of 3 1 2 3