are you reading all of the rows at once? It is possible that the
results set is too large to fit into memory- get a count of the number
of rows that would be returned to eliminated that as a possibility.
On 07/01/2013 06:20 PM, KOTAGIRI, RAMPRASAD wrote:
Environment:
Perl v5.8.4 built
I want to write a query like:
select clients.client.client_id, columnar.sales.total_sales,
web.page_hits from clients, columnar, web
where clients.client_id = columnar.client_id
and clients.client_id = web.client_id
in a system where 'clients' is actually one or more relational
databases,
can you run strace, or the HP equivalent, to see what system calls are
getting made and what files are and are not found?
the system call that doesn't return is likely where the problem is.
Check the time stamp of any file that is loaded to see if it was changed
recently. Any file that it
Thank you all for your replies. I am indeed talking about working with
multiple back ends (oracle, mysql, or any valid DBI module) in the same
query.
I'll post any follow-up questions to the dev list.
Andrew
On 06/26/2013 08:26 AM, Andrew Snyder wrote:
I want to write a query like:
select