Hi  Zoho!

Sorry for being too aggravating and thanks for being supportive and active!

Anyway, I'm facing a new problem. I  used lookup in some of my tables (about 3 columns).

I successfully have them joined via lookup, but I cannot import CSV file (50k Records) to my table or it takes too long.

I wanted to use the Query Table but it limits to only 800,000 records.

 
What are the limitations in using the lookup? Will I encounter more unexpected errors?

Almost columns are in Plain Text format, changing it to number/decimal, will it improve the performance?

Please suggest some tips and tricks to improve performance on importing/generating data in a table with lookups.

And one more thing:

Any suggestion on deleting all rows? We have this same indexed table in my colleague's account and i have problems in deleting all rows with less than a million record count. How can I optimize the deletion process? My client is going to delete all row data with approx. 1M record count after every analysis.

I am also helping my colleague with the use of Zoho Reports so I kind of need some solutions for my problems :)

Thanks and more power to you guys!

CJ