02-20-2019
Quote:
Originally Posted by
figaro
I have a big, ugly query which is quadratic in the input size and therefore want to display an approximate completion time prior to sending it off:
I don't see the link between what you want and the query and like you have said it's not correct. So, to analyze the query you have the explain command to get information about the plan that will be used and from there you can estimate quick query and slow query.
See the official web site for "EXPLAIN"
The other option is to do it on the application side.
8 More Discussions You Might Find Interesting
1. Programming
Hi there,
I have a hierarchical database that include 4 tables. Table A is the parent of B, B is Parent of C, C is parent of D. If I want to query everything in D that is associated with A.name, how do I do that? Thanks!
YanYan (0 Replies)
Discussion started by: pinkgladiator
0 Replies
2. Shell Programming and Scripting
Hi there, I have a table that stores multiple records for many different servers, each of which is timestamped ... I wanted to write a query that would enable me to only output the "latest" record (based on timestamp) for each "unique" server. So for example my main table looks like this
... (3 Replies)
Discussion started by: hcclnoodles
3 Replies
3. Web Development
hello all
i have 2 columns every column in the following format
column1
2011-04-01 11:39:54
column2
2019-02-03 00:00:00
i want get difference between above data as following
2 days 11:39
how to do so ?
i tried many functions but nothing works
please advice what is the query... (6 Replies)
Discussion started by: mogabr
6 Replies
4. Shell Programming and Scripting
Hi,
I want to access mysql query from database , for that i have tried the below code
#! /bin/bash
TABLE_NAME=database1
USER_NAME=root
IP_ADDR=111.20.9.256
somevar=`echo "select altid from alert where altid='2724'"| mysql -h $IP_ADDR -u $USER_NAME $TABLE_NAME `
echo $somevar
... (1 Reply)
Discussion started by: aish11
1 Replies
5. Programming
Hi,
I want to run below query on shellscript but having one problm.
ADV=$( mysql -h "$IP_ADDR" -u "$USER_NAME" "$TABLE_NAME" -BNe" SELECT ADV FROM indata where inid='$INSTRUID' and Date='$latest Date';" )
here Date column contans different below dates
2011-12-01... (0 Replies)
Discussion started by: aish11
0 Replies
6. Shell Programming and Scripting
Hi,
I want to run below query on shellscript but having one problm.
ADV=$( mysql -h "$IP_ADDR" -u "$USER_NAME" "$TABLE_NAME" -BNe" SELECT ADV FROM indata where inid='$INSTRUID' and Date='$latest Date';" )
here Date column contans different below dates
2011-12-01... (11 Replies)
Discussion started by: aish11
11 Replies
7. Programming
Hello
i have created mysql query to compare to values and get difference in percentage
as following:
SELECT file_name, 100 - ((100 * (SELECT file_count FROM xipi_files z WHERE x.file_group = z.file_group AND x.file_name = z.file_name AND z.insert_date = CURDATE( ) - INTERVAL 1 DAY)) /... (1 Reply)
Discussion started by: mogabr
1 Replies
8. Programming
Hi All,
i have a table in mysql with the following data
Table name Test
Assettype Serial_No Status location
Mouse 123456 In Stock chennai
Mouse 98765 Allocated chennai
Keyboard ... (2 Replies)
Discussion started by: venkitesh
2 Replies
LEARN ABOUT DEBIAN
rdf::query::plan::service
RDF::Query::Plan::Service(3pm) User Contributed Perl Documentation RDF::Query::Plan::Service(3pm)
NAME
RDF::Query::Plan::Service - Executable query plan for remote SPARQL queries.
VERSION
This document describes RDF::Query::Plan::Service version 2.908.
METHODS
Beyond the methods documented below, this class inherits methods from the RDF::Query::Plan class.
"new ( $endpoint, $plan, $silent, $sparql, [ \%logging_keys ] )"
Returns a new SERVICE (remote endpoint call) query plan object. "<$endpoint"> is the URL of the endpoint (as a node object). "<$plan">
is the query plan representing the query to be sent to the remote endpoint (needed for cost estimates). "<$sparql"> is the serialized
SPARQL query to be sent to the remote endpoint. Finally, if present, "<%logging_keys"> is a HASH containing the keys to use in logging
the execution of this plan. Valid HASH keys are:
* bf - The bound/free string representing C<<$plan>>
"new_from_plan ( $endpoint, $plan, $context )"
Returns a new SERVICE query plan object. "<$endpoint"> is the URL of the endpoint (as a string). "<$plan"> is the query plan
representing the query to be sent to the remote endpoint. The exact SPARQL serialization that will be used is obtained by getting the
originating RDF::Query::Algebra object from "<$plan">, and serializing it (with the aid of the RDF::Query::ExecutionContext object
"<$context">).
"execute ( $execution_context )"
"next"
"close"
"endpoint"
"sparql"
Returns the SPARQL query (as a string) that will be sent to the remote endpoint.
"lhs"
"silent"
Returns a boolean value indicating whether the service plan will ignore errors.
"pattern"
Returns the query plan that will be used in the remote service call.
"distinct"
Returns true if the pattern is guaranteed to return distinct results.
"ordered"
Returns true if the pattern is guaranteed to return ordered results.
"plan_node_name"
Returns the string name of this plan node, suitable for use in serialization.
"plan_prototype"
Returns a list of scalar identifiers for the type of the content (children) nodes of this plan node. See RDF::Query::Plan for a list of
the allowable identifiers.
"plan_node_data"
Returns the data for this plan node that corresponds to the values described by the signature returned by "plan_prototype".
"graph ( $g )"
"explain"
Returns a string serialization of the query plan appropriate for display on the command line.
AUTHOR
Gregory Todd Williams <gwilliams@cpan.org>
perl v5.14.2 2012-01-31 RDF::Query::Plan::Service(3pm)