MySQL Forums
Forum List  »  PHP

Use Java and PHP to access temporary table?
Posted by: Arthur Chan
Date: March 20, 2019 09:33PM

The business requires the display of a spreadsheet-like table from a series of complex queries, then plot each data series in an XY graph.

Although they can be joined or union-ed together, in all cases, some data is lost. Also, the query and subqueries are very expensive.

I am considering a temporary table to hold the data for a given date range, then use JAVA and Android to access the temporary table.

QUESTIONS:
*** Is it possible to use Java or Android to access a temp table created by a sproc that I execute in PHP?
*** Any pitfalls what I should be aware of?

Options: ReplyQuote


Subject
Written By
Posted
Use Java and PHP to access temporary table?
March 20, 2019 09:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.