[SOLVED] why appwrite (console) shows only 5k documents, but there is more then 10k documnets

why appwrite (console) shows only 5k documents, but there is more then 10k documnets

TL;DR

The user was experiencing an issue where the Appwrite console was only showing 5k documents instead of the expected 10k. However, the user later thanked for the solution, but it is not mentioned in the thread. There were also questions about using attributes, indexes, and queries. The user wanted to arrange data in ascending order using timestamps but did not fully understand the solution provided. The user asked how to make backups and delete all documents in a single click. The solution provided was to create a script for the database creation to easily delete and recreate the collection. Alternatively, accessing the database directly and emptying the collection table

There is an hard limit on regular pagination. up to 5K only.

is there is any way to search documents on console

I don't think so

and for deleting all documents in single click

Also, I think the only to delete is by ID. It would be nice if you can empty collection.

For now you can

Make sure your database creation is in a script then it would be easy to delete and recreate the collection.
Access the database directly and empty the collection table.

As for any database action I recommend you back up every thing before.

How can i make backup.

Check these two Backup scripts

ok,

How to use index for asc and dsc with respect to time

Didn't got it

means, how can i arrange my data in ascending order using time stamp,

You can use one of these queries

https://appwrite.io/docs/queries#query-class

can i also use index?

You can use the attribute on if it is an index one then it will work faster But as of version 1.3.0 it will work in any case.

ok, what is the use of Key and Full Text in index Type, as i am only aware with Unique