Jump to content
  • 0
Sign in to follow this  
JckDY

Table records

Question

3 answers to this question

Recommended Posts

  • 0

JckDY,

I have been able to store 3M records, but I believe now with recent system upgrades it can store more. The main factor is the table file size (not records). When the table file size reaches 1GB it can cause it to freeze up. Caspio recommends number of columns to be no more than 255, but I have reached 365 before. That was my experience prior to recent upgrades so it may have increased since.

Share this post


Link to post
Share on other sites
  • 0

Hi @JckDY,

Just to add up to the comment above, I believe you can have 10M records or more in one table. As long as you still have free DataBase space/storage in your account (This varies depending on your plan). And to ensure that your application is optimized, for best practices, it is advisable to have 255 or less columns/fields in your table.

For more details about best practices in creating your app, you can check this Article .

And to see the DataBase size/storage of each plan you can check these links. Standard Plans | Premium Plans

I hope this helps.

Regards,

TsiBiRu

Share this post


Link to post
Share on other sites
  • 0

So I was told by the awesome Caspio Support people some useful information about your inquiry.

While it is true that you can add up to 10 million records per table, you will start having lots of performance issues the moment it reaches to let say one million.

For example, you have a table with 1m+ records and then combined it to another table through a view and used it as the data source of a Report DataPage. You will experience very noticeable and increasing delays. 

It's always best to stay a little lower than a million. You can always do some archiving for old records so it won't add to the pain. Also, it'll free up some space so you won't have to purchase extra storage. It's always a good practice to trim everything down you know!

CASPIO Rocks!!!

 

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
Sign in to follow this  

×
×
  • Create New...