Back

Create index in cloud

  • 1
  • Databases
  • Cloud
Mosh Ontong
3 Jul, 2023, 05:53

I am creating an index in my collection, why it takes so long to process until now. So I tried to create new index, but still the same error. Then trying to delete, it does not reflect to delete the specific index I have created.

TL;DR
User is seeking guidance on creating an index in the cloud, specifically asking if they should choose "key" or "unique" instead of "full text". Others in the thread explain that full text indexing may not be appropriate in this case. The thread also discusses a processing delay during daily backups and the limitation of creating a full text index on a datetime attribute. User mentions encountering the same processing issue when creating new attributes. User updates that they are still experiencing issues creating and deleting indexes in their collection. No solution provided in the thread.
Mosh Ontong
3 Jul, 2023, 06:07

new update

Mosh Ontong
3 Jul, 2023, 06:07

it failed to create this index

kamal.panara
3 Jul, 2023, 06:08

same processing tag in attributes too when I created new attributes! looks like there is something wrong with Appwrite cloud.

Meldiron
3 Jul, 2023, 11:04

Hey there πŸ‘‹ During daily backups, index creation can be stuck at processing for ~15 minutes. Eventuelly, it will run. We are aware of this limitation and are working towards a better backup strategy πŸ™

Regarding failed status, it failed because it's not possible to create fulltext index on $cratedAt, which is datetime attribute. fulltext indexes only work properly on string attributes I believe. Any reason you wanted to mark this idnex of type fulltext, and not key or unique?

Mosh Ontong
3 Jul, 2023, 11:07

I want to use the fulltext it becasue i am using the Query.search, to search if this specific email is exist or not

Drake
3 Jul, 2023, 13:07

Why not use the equal query?

Mosh Ontong
3 Jul, 2023, 15:38

ohhhh I seeee so in that case I will not choose full text? what do I choose key or unique?

Drake
3 Jul, 2023, 15:39

If you need the attribute to be unique across all documents in the collection, choose unique. Otherwise, choose key

Mosh Ontong
3 Jul, 2023, 16:00

than you so much steven

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more