You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Temp tables in appengine

5 replies [Last post]
deepikakubba's picture
User offline. Last seen 9 years 4 weeks ago. Offline
Joined: 06/29/2010
Posts: 26

Hi,

Can anybody give an overview of temp tables.. like where extacly we can make use of it and any practical example of that.

Thanks ,
Deepika

anithan's picture
User offline. Last seen 10 years 30 weeks ago. Offline
Joined: 06/29/2010
Posts: 31
Re: Temp tables in appengine

Temp tables are used in parallel processing
i.e at a time more than one user can access the same table(i.e instances).
we can specify the instances of our temporary table via online,batch processing
in Batch processing AE properties we have to specify our temp table and no of instances(After specifing the instances ,we msut rebuild our temp table )
in Online processing ..
pT-> utilities-> Admin->pt options...
here we set globally for all temp tables ..

deepikakubba's picture
User offline. Last seen 9 years 4 weeks ago. Offline
Joined: 06/29/2010
Posts: 26
Re: Temp tables in appengine

Hi,

Thanks alot for the info.
but i still have questions abt practical example like in AET record we simply put the data from main record and then fetch it .using
%select and %bind .

So is it like temp tables r only used when many ppl want to use d same table?

Thanks,

anithan's picture
User offline. Last seen 10 years 30 weeks ago. Offline
Joined: 06/29/2010
Posts: 31
Re: Temp tables in appengine

ya sure temp tables are used for that purpose only
and one more case which i know
is
if the original table is having 1000 rows and i don't need all those row
i.e i want to do operations (modifications) on 100 rows only.
in this case i will fetch those 100 rows in to temp table and do modifcatons and again put the modifiec data back to the original table

deepikakubba's picture
User offline. Last seen 9 years 4 weeks ago. Offline
Joined: 06/29/2010
Posts: 26
Re: Temp tables in appengine

Hi,

Thanks alotttt.
I got cleared my concept of Temp table now.
Thanks again,
Deepika

Ashar's picture
User offline. Last seen 5 years 1 week ago. Offline
Joined: 03/26/2008
Posts: 227
Re: Temp tables in appengine

you may find this link helpful.