Forum: VoltDB Architecture

Post: Stored Procedure for each where clause

Stored Procedure for each where clause
gambitg
Sep 20, 2012
Hi,
I have a table with 100 odd columns and a index on each of the columns.


The query pattern can be AND of more than columns upto 100 columns.
(example: select key from table where column1 > val1 and column1 < val2 and column2 > val3 and column2 < val4 and ...... )


Do I need a stored procedure for each of such combination of where clause ?


All queries are run frequently and performance is very important for each type of query.


Thanks.
Stored Procedure for each where clause
awilson
Sep 21, 2012
Hi,


Could you send me a brief description of your project, the project.xml, your ddl and an example query to awilson at voltdb.com ?