What are the limitations of PS query?

Questions by SaiKr

Showing Answers 1 - 15 of 15 Answers

h

  • May 6th, 2007
 

You cannot use temp tables in PS query.

  Was this answer useful?  Yes

sharry

  • Dec 19th, 2007
 

The biggest disadvantage is that PS queries cannot be used to perform DML(update,insert,detele) operations. It can only fetch data(Select).
Further, as the use of temp table was mentioned in one of the answers, I will like to add - how many times our temp records have data in database, arent they cleaned before our prog ends......so y will we use temp tables in a select query.

  Was this answer useful?  Yes

mmtani

  • Jan 10th, 2008
 

Many more recent App Engine programs clear out the tao tables at the beginning, and leave the data in there at the end, so that you can use it (until another program instance picks up those tables and uses them) to debug.

  Was this answer useful?  Yes

sharry

  • Jan 10th, 2008
 

@ mmtani

You are absolutely correct in your statement, but leaving the temp table with data and clearing it before next use is not a good programming practice isint it.
This is the reason I wrote the above thing.

  Was this answer useful?  Yes

sreddy09

  • Jun 10th, 2009
 

The other limitation of PS query is that if the resultset of the query is too large, then not all the data can be extracted into Excel or CSV file due to file size limitations.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions