Object creating takes very long in ios (react native) #2845

idanCemento · 2020-04-27T15:31:33Z

recently updated from 3.6.4 to 5.0.3.
object creating takes much longer that it used to on both simulators and iphones + blocks ui.

Expected Results

quick creating as it used to be

Actual Results

average object creation takes about 400ms and blocks the ui

Code Sample

postRealm.write(() => {
	if (cleanAll) {
		let allPosts = postRealm.objects('post24').filtered('projectId = "' + projectId + '"');
		let allLastUpdateTS = postRealm.objects('lastUpdateTS').filtered('projectId = "' + projectId + '" AND type = "post"');
		postRealm.delete(allLastUpdateTS);
		postRealm.delete(allPosts); 
	}
	
	preparedPostArray.forEach(post => {
		if (post && post.id) 
			postRealm.create('post24', post, true);
		else {
			console.warn('post missing ID'); 
		}
	});

	if (projectId && ignoreTimestamp)
		postRealm.create('lastUpdateTS', { id: projectId + '_post', lastUpdateTS: newLastUpdateTS, projectId, type: 'post' }, true)
});

Versions

Realm JS SDK Version: 5.0.3
React Native: 0.61.5
Client OS & Version: macOs Catalina 10.15.4

The text was updated successfully, but these errors were encountered:

eladgel · 2020-04-28T08:15:42Z

Did the same update and just noticed this too, I've also noticed that when you update an entity you encounter the same issue

bmunkholm · 2020-04-28T08:26:35Z

Thanks for reporting this @eladgel @idanCemento !
Could any of you possibly provide a self contained sample project that shows this? That would be really helpful so we have something concrete.

idanCemento · 2020-04-30T07:17:53Z

sorry.. i can't share my project but it used to work very fast before the update

bmunkholm · 2020-04-30T08:35:18Z

@idanCemento We certainly don't need your full project, but if you could make a small self-contained repro-case which simulates what you do, that would be super helpful. We have no idea what your model looks like and how much data you are adding in those objects.

idanCemento · 2020-04-30T09:20:06Z

It's complicated.
There are thousands of objects, most of them refer to many other models in the system which also has thousands or hundreds of objects.
The update is done in one batch but for some reason it takes very long to do every iteration in the transaction.
Every thing is indexed

bmunkholm · 2020-04-30T12:01:11Z

Every thing is indexed
That can have an impact on insertion time.
How many properties are indexed?

Without an understanding of a synthetic way to reproduce this, it will be hard for us to understand and help.

eladgel · 2020-04-30T18:55:34Z

@idanCemento Can you try removing the indexed property just for the test?
@bmunkholm I have the same issue almost exactly, it happens in an object that holds objects, that some of them have more objects and some have list of objects. I think that my hierarchy goes 4-7 levels deep in total, where every level creates a new object/list of objects

bmunkholm · 2020-04-30T21:08:55Z

@eladgel Thanks for the feedback!
If you have a way to make a minimal repro-case with something similar to what your do - or whatever is needed to show the issue, we would be super grateful!
Issues with repro-cases typically get's the highest priority ;-)

Ilann0 · 2020-05-03T07:15:33Z

+1

tomershohet · 2020-05-03T07:34:15Z

+1

tomershohet · 2020-05-13T15:01:17Z

@blagoev We found more info regarding this issue.

On an object that have only native properties it work fine.
Then - with each property that being linked to an other property type, it add ~20 milisec to the create action.

That happen only if the property does have a value that need to be set.
Each property adds about 20 milisec, so an object with 10 linked properties, would take about 200 milisec per object. On out case we have around 50K objects, so it would take a couple of hours...
The problem only exist on IOS - on Android it works fine (About 0-1 milisec per linked property)

bmunkholm · 2020-05-13T15:54:12Z

@tomershohet That's great! Could you possibly cook that down to a minimal repro case that demonstrate this? That would be highly appreciated!

tomershohet · 2020-05-14T16:50:52Z

@bmunkholm It happen on every create with an object that have any link to another object.
Neither of the object don't have anything other then id (And the first one have a link to the second).
With every create - it would take about 20 milisec on IOS to add that object.

blagoev · 2020-05-14T17:07:31Z

@tomershohet Thanks for the information. Could you possibly share a simple schema that we can use to reproduce this.

cheers.

idanCemento · 2020-05-17T08:28:07Z

schema:

export const parentSchema = {
  name: 'parent',
  schemaVersion: 1,
  properties: {
    id:'string',
    child: 'child'
  }
};

export const childSchema = {
  name: 'child',
  schemaVersion: 1,
  properties: {
    id: 'string'
  }
};

code:

function testRealmObject(realmInstance) {
	let parentRealm = realmInstance.parent;
	parentRealm.write(() => {
		for (let i = 0; i < 55; i++) {
			let obj = {
				id: `parent${i}`,
				child: {
					id: `child${i}`
				}
			};
			let startTS = new Date();
			parentRealm.create('parent', obj);
			console.log("TCL: testRealmObject -> parentRealm.create ", new Date() - startTS);
		};
	});
}

output:

'TCL: testRealmObject -> parentRealm.create ', 25
'TCL: testRealmObject -> parentRealm.create ', 25
'TCL: testRealmObject -> parentRealm.create ', 22
'TCL: testRealmObject -> parentRealm.create ', 22
'TCL: testRealmObject -> parentRealm.create ', 24
'TCL: testRealmObject -> parentRealm.create ', 23
'TCL: testRealmObject -> parentRealm.create ', 23
'TCL: testRealmObject -> parentRealm.create ', 23
'TCL: testRealmObject -> parentRealm.create ', 23
'TCL: testRealmObject -> parentRealm.create ', 22
'TCL: testRealmObject -> parentRealm.create ', 23
'TCL: testRealmObject -> parentRealm.create ', 28
'TCL: testRealmObject -> parentRealm.create ', 27
'TCL: testRealmObject -> parentRealm.create ', 23
'TCL: testRealmObject -> parentRealm.create ', 24
'TCL: testRealmObject -> parentRealm.create ', 21
'TCL: testRealmObject -> parentRealm.create ', 20
'TCL: testRealmObject -> parentRealm.create ', 21
'TCL: testRealmObject -> parentRealm.create ', 23
'TCL: testRealmObject -> parentRealm.create ', 21
'TCL: testRealmObject -> parentRealm.create ', 20
'TCL: testRealmObject -> parentRealm.create ', 22
'TCL: testRealmObject -> parentRealm.create ', 24
'TCL: testRealmObject -> parentRealm.create ', 21
'TCL: testRealmObject -> parentRealm.create ', 21
'TCL: testRealmObject -> parentRealm.create ', 22
'TCL: testRealmObject -> parentRealm.create ', 22
'TCL: testRealmObject -> parentRealm.create ', 22
'TCL: testRealmObject -> parentRealm.create ', 21
'TCL: testRealmObject -> parentRealm.create ', 25
'TCL: testRealmObject -> parentRealm.create ', 24
'TCL: testRealmObject -> parentRealm.create ', 21
'TCL: testRealmObject -> parentRealm.create ', 23
'TCL: testRealmObject -> parentRealm.create ', 22
'TCL: testRealmObject -> parentRealm.create ', 23
'TCL: testRealmObject -> parentRealm.create ', 24
'TCL: testRealmObject -> parentRealm.create ', 23
'TCL: testRealmObject -> parentRealm.create ', 22
'TCL: testRealmObject -> parentRealm.create ', 21
'TCL: testRealmObject -> parentRealm.create ', 24
'TCL: testRealmObject -> parentRealm.create ', 22
'TCL: testRealmObject -> parentRealm.create ', 20
'TCL: testRealmObject -> parentRealm.create ', 20
'TCL: testRealmObject -> parentRealm.create ', 22
'TCL: testRealmObject -> parentRealm.create ', 23
'TCL: testRealmObject -> parentRealm.create ', 21
'TCL: testRealmObject -> parentRealm.create ', 21
'TCL: testRealmObject -> parentRealm.create ', 23
'TCL: testRealmObject -> parentRealm.create ', 23
'TCL: testRealmObject -> parentRealm.create ', 21
'TCL: testRealmObject -> parentRealm.create ', 21
'TCL: testRealmObject -> parentRealm.create ', 23
'TCL: testRealmObject -> parentRealm.create ', 24
'TCL: testRealmObject -> parentRealm.create ', 21
'TCL: testRealmObject -> parentRealm.create ', 21

@blagoev
@tomershohet

tomershohet · 2020-05-21T08:54:32Z

Hi, Any updates on the issue? @blagoev

idanCemento · 2020-05-24T15:23:55Z

hey, I created a sample project that reproduce the issue.

https://github.com/idanCemento/realm-performance

On my IOS simulator, it takes on average 14.41 ms to create an object with reference and 0.03 ms to create a simple object

@bmunkholm @blagoev

idanCemento · 2020-05-25T08:45:11Z

on my ipad the performance are even worse

tomershohet · 2020-05-25T10:10:22Z

32 millisecond per object.
On a usual case where we have about 5K objects, it would take almost 3 minutes...

It wasn't that why on previous versions, i believe it stated acting this way on version 5.
Obviously this issue is critical for anyone who uses realm with big data.

Please prioritize this as it is a showstopper.

Thanks

bmunkholm · 2020-05-25T10:43:42Z

Thanks all - highly appreciate the repo. We will investigate further.

idanCemento · 2020-05-31T12:59:26Z

hey, any news with this issue?
please update if it was or will be investigated.

I'm worried that at this point we should already consider moving our app to use another
DB..

please help

bmunkholm · 2020-06-02T12:50:58Z

We surely will investigate this further. There are some other high priority issues being handled right now, so I don't expect this can be looked at until next week.
As a temporary workaround would it be possible for you to downgrade until we have a fix for this?

idanCemento · 2020-06-02T14:00:12Z

As a temporary workaround would it be possible for you to downgrade until we have a fix for this?

unfortunately no... last versions don't support latest versions of node while react native already requires node@12

blagoev · 2020-06-02T15:14:46Z

Hi,
It is in our high priority list to check. I hope next week we will be able to investigate this.

tomershohet · 2020-06-08T14:35:23Z

Hi, @blagoev
is there any update by any chance?
The entire release is waiting for this :-}

jimsideout · 2020-06-22T00:10:36Z

+1

WJimmyCook · 2020-06-23T13:13:58Z

I have a single write transaction that creates a bunch of linked objects. Using the latest release it took my app around 110 seconds to complete. I downgraded to version 3.6.5 and the same write transaction took less than 1 second!

One interesting thing to note -- with the latest release if I enable remote debugging then the write transaction is much faster. It's actually even faster than the release build.

bmunkholm · 2020-06-23T13:15:58Z

@WJimmyCook And this is also just on iOS, and not on Android?

WJimmyCook · 2020-06-23T13:21:12Z

@bmunkholm Yeah, this is for iOS. I'm not working on an Android version for this app so I'm not sure what Android is like.

steffenagger · 2020-06-23T14:02:16Z

@bmunkholm I ran @idanCemento's realm-performance on iOS & Android - the bug is iOS specific. See screenshots:

mirkodrummer · 2020-08-04T07:46:14Z

Hi there! I'm having the same issue developing an iPad app. Is there any update on this?

blagoev · 2020-08-17T07:34:35Z

This is fixed and will be part of our next release. @idanCemento thanks for the top notch report and repro app.
cheers

RealmBot · 2020-08-17T07:41:00Z

➤ Lyubomir Blagoev commented:

fixed in #3136 ( #3136 )

realm-probot bot added the O-Community label Apr 27, 2020

RealmBot assigned blagoev May 3, 2020

bmunkholm added the T-Bug label Jun 2, 2020

RealmBot unassigned blagoev Jun 2, 2020

RealmBot assigned blagoev Jun 23, 2020

bmunkholm mentioned this issue Jun 24, 2020

Slow performance on writing multiple objects at a time #2989

Closed

This was referenced Aug 14, 2020

v10: Fix create performance in RN on iOS #3136

Merged

v6: fix object create peformance on RN iOS #3137

Merged

blagoev closed this as completed in #3137 Aug 17, 2020

ferrannp mentioned this issue Nov 24, 2020

v5: fix object create peformance on RN iOS #3422

Closed

github-actions bot locked as resolved and limited conversation to collaborators Mar 15, 2024

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Object creating takes very long in ios (react native) #2845

Object creating takes very long in ios (react native) #2845

idanCemento commented Apr 27, 2020 •

edited by sync-by-unito bot

Loading

eladgel commented Apr 28, 2020

bmunkholm commented Apr 28, 2020

idanCemento commented Apr 30, 2020

bmunkholm commented Apr 30, 2020

idanCemento commented Apr 30, 2020

bmunkholm commented Apr 30, 2020

eladgel commented Apr 30, 2020

bmunkholm commented Apr 30, 2020

Ilann0 commented May 3, 2020

tomershohet commented May 3, 2020

tomershohet commented May 13, 2020

bmunkholm commented May 13, 2020

tomershohet commented May 14, 2020

blagoev commented May 14, 2020

idanCemento commented May 17, 2020 •

edited

Loading

tomershohet commented May 21, 2020

idanCemento commented May 24, 2020

idanCemento commented May 25, 2020

tomershohet commented May 25, 2020 •

edited

Loading

bmunkholm commented May 25, 2020

idanCemento commented May 31, 2020

bmunkholm commented Jun 2, 2020

idanCemento commented Jun 2, 2020

blagoev commented Jun 2, 2020

tomershohet commented Jun 8, 2020

jimsideout commented Jun 22, 2020

WJimmyCook commented Jun 23, 2020

bmunkholm commented Jun 23, 2020

WJimmyCook commented Jun 23, 2020

steffenagger commented Jun 23, 2020

mirkodrummer commented Aug 4, 2020

blagoev commented Aug 17, 2020

RealmBot commented Aug 17, 2020

Object creating takes very long in ios (react native) #2845

Object creating takes very long in ios (react native) #2845

Comments

idanCemento commented Apr 27, 2020 • edited by sync-by-unito bot Loading

Expected Results

Actual Results

Code Sample

Versions

eladgel commented Apr 28, 2020

bmunkholm commented Apr 28, 2020

idanCemento commented Apr 30, 2020

bmunkholm commented Apr 30, 2020

idanCemento commented Apr 30, 2020

bmunkholm commented Apr 30, 2020

eladgel commented Apr 30, 2020

bmunkholm commented Apr 30, 2020

Ilann0 commented May 3, 2020

tomershohet commented May 3, 2020

tomershohet commented May 13, 2020

bmunkholm commented May 13, 2020

tomershohet commented May 14, 2020

blagoev commented May 14, 2020

idanCemento commented May 17, 2020 • edited Loading

tomershohet commented May 21, 2020

idanCemento commented May 24, 2020

idanCemento commented May 25, 2020

tomershohet commented May 25, 2020 • edited Loading

bmunkholm commented May 25, 2020

idanCemento commented May 31, 2020

bmunkholm commented Jun 2, 2020

idanCemento commented Jun 2, 2020

blagoev commented Jun 2, 2020

tomershohet commented Jun 8, 2020

jimsideout commented Jun 22, 2020

WJimmyCook commented Jun 23, 2020

bmunkholm commented Jun 23, 2020

WJimmyCook commented Jun 23, 2020

steffenagger commented Jun 23, 2020

mirkodrummer commented Aug 4, 2020

blagoev commented Aug 17, 2020

RealmBot commented Aug 17, 2020

idanCemento commented Apr 27, 2020 •

edited by sync-by-unito bot

Loading

idanCemento commented May 17, 2020 •

edited

Loading

tomershohet commented May 25, 2020 •

edited

Loading