XAF XAFers Community Standup, 10 Dec 2020

Previous Meeting Next Meeting

⏯

youtube image

►

From YouTube: XAFers Community Standup - December 10th 2020 - Let's talk about Performance

Description

Click Here to Subscribe: http://xaf.life/35
XAF Myth #2: https://xafmarin.com/xaf-myth-2-performance-is-not-good/

Source code: https://github.com/jjcolumb/XafDataAccess

Join us the second Thursday of every month for our community standup covering everything that is going on with XAF, XPO, Blazor and more. There is no agenda, no formality, no dress code required, let's just talk about what we love and share our experiences.

Websites:
https://xafmarin.com/
https://www.xafers.training/
http://xafersweekly.com/
https://www.xari.io/

Free XAF Support Hour
https://calendly.com/xari/free-xaf-support-hour

Facebook Group
http://xaf.life/4g

A

We are live and, as always, thank you guys for coming. We this is the staffers community stand up. We do it. The second thursday of every month is the the vacation day for our for our company is. I know we have a weird vacation concept, but this is the time that we just get to share our experience with the community.

A

Talk about what we like, what we love and today topic is really special because last meet up, we already break a soft myth, number one number one that the ui was not customizable and we are still getting more screenshots from the community that I will be adding to that post. But today we're going to have a different approach. We're going to talk about performance. Some other break is that you cannot have really performance application with staff. I guarantee we're going to break that myth today as well.

A

So when someone else tell you about this, you just refer to this video to this community and, of course, as always, feel free to ask as many questions as you have. We have dennis here with us, so thank you danny for showing up for participating in our community, so he will be answering questions on the chat, as always as well as manuel jose and myself will be here for any any question that you guys have. As always, I always say that there is no formal dress require a beer is in chorus.

A

Let's just talk about what we like before moving forward. As always, I want to encourage everyone to join the community. We have our meet up that, of course, you are here today. You know about it, but we have a linkedin group. We have our facebook group that is 805 members this month. So thank you for that. Thank you for joining in. We have please follow staff on twitter. If you want to know everything that is happening, the new announcement, the news, support the new documentation.

A

This is a great place because we are going to get here everything we need hey. I think that I I know we I didn't miss subscribe to suffer quickly to get a interesting links about chat and join the community channel get a channel. I would like to have more presents. I think that we only have like 39 40, even if in facebook we have 800, so everyone who is watching this please join here.

A

There is a lot of great conversation happening here, and one of the best example is one of the suffers from the community dom sinclair eh. Let me join here quickly.

A

Okay, dom sinclair, he is sharing actually a context, help controller where he go about how he's implementing help a feature in his application. So this is the type of things that I really love to see community interacting themselves, community helping himself so please feel free to join. There is a great conversation right here. There are uh dave manuel dennis josh. Everyone is answering questions. Everything is collaborating together, so please do it so for today, let's get to the point of what we have today, what we have, as always, I can't forget.

A

We are part of the net foundation user group. They always ask you to say this. If you want to see really nice events about what is happening in the net ecosystem go there, there are a lot of events every month. I think that there are too many that you cannot keep up without your work and actually following everything.

A

That's going on only for summer in last month, the world, like eight conference- something crazy like that, but it is a great place to get nice information and to be up to speed on everything that is going on. So, for now, les has always I'm pretty sure that everyone here knows the speakers that I would like manuel dennis and roger to introduce themselves against it and meeting people. I love seeing people showing up here, even if they can watch it later on youtube.

A

Hey we're going to do a quick announcements, a go about everything that is going is happening in south. We are going to talk about the testimonials that the suffrage has provided about the performance, and I want to say again thank you all the sufferers for showing me sending us a screenshot about ui customization. Thank you for sending us all these testimonial samples about performance.

A

This is just a highlight of my months of my day, so we're going to talk later about performance in general data access mode m, plus one issues that on the orm we're going to talk about ways to go about, not loading all the data xp view. I split query that review we're going to talk about the profilers, we're going to get every question that you guys uh come up with that. I can wait for them and we're going to definitely break the myth that saf is not performance. I guarantee you.

A

We have seen south application with excellent performance. Is your use not to know how to modify itself already take care from you of all this low task? Ui generation, database creation, everything and you are able to fine-tune the ui to fine-tune the performance, maybe I'm biased, but I don't see a better way to produce light and fusion application. This is amazing. So from there I think that we're good to go manual, please introduce yourself, then hodgson and dennis, and then we can start.

B

All right manuel, I am at express mvp since a lot of years. I have no idea. The same talk is every every time with a lot effect in xf, but not only in xf and alder.net space and uh I'm a long term xf and xpo user all over the place. They call it whatever.net technology or microsoft technology, whether the beds yeah and read my blog there's a lot of interesting stuff. I think we will see a little bit of that today and so I will hand over to dennis.

C

uh Thank you, my name is denis. I work for devexpress. I am a product manager for the xav team.

C

Thank you for the.

D

C

To present here today,.

D

Okay, I guess it's my turn. um My name is joche jochejera, I'm part of bit framework ansari and also at the x-rays mvp. I mean we do code every day, every single hour. So that's what we're here to talk about?

D

A

D

A

Javier, no okay, perfect, no again and the new snvp like three days ago and I'm so so proud so proud and so so excited to be able to say that I have followed a manuel jose dennis dave, adam and martin, for so many years have been able to have this space to discuss what we like and will office is a dream come true. So with that out of the way uh I wanna quickly just say a thank you for everyone again who provided a video about a performance, optimization, don't and stuff.

A

It's amazing see the community helping us out here. I want to thanks, especially so, if we see the videos here, keith is one of the staffers who provide the video and he's here on the chat, a young paul. He provides another video hey, thank you guys for for for being part of the community and helping someone else to prove that job performance is good.

A

When we understand how everything is happening, how the data access work, how the how staff is doing everything, because again one of the base safe, our staff is that that is completely transparent. We can see the source code, we can see how things are being uh implemented and we can use that in our advantage. So with that out of the way, I want to say everyone who provides a video about soft performance, optimization they are, they will get a free stuff course.

A

So I know, for example, that most probably a young power, maybe even case they don't need that. But if someone in your company, your developer or anything, need that course feel free to send us an email, and we will include it because we want to again hey.

A

We are thankful for you guys, helping us out and providing this example, because we want to show the world what we already know. That chaff is a great friendly to develop planning applications. So again, thank you. Everyone right here, thanks alejandro he's in spanish, but whoever for the suppers who speak spanish thanks for the for the testimonial thanks a everyone and right here, is our humble, appoint from ho chi minh. So, let's just quickly just talk about this quickly.

A

This is a great example that we have about the performance of some calculations that were being done and right here we can see how a big improvement is from like 3-4 minutes to like a couple seconds. It's interesting. We can also see here at real and I love to see real life application doing stuff like this one. There is an animal rescue example. So thank you where we can see that he has a lot of pictures. He has a lot of reports and how the performance get improved right here alejandro.

A

He has a crazy, crazy calculation that I don't know exactly what is happening here. What he's doing you have to be some nasa calculation or something, but it was taking like 12 hours and he was able to reduce it to 30 minutes right here we can see- and we will see this today- the difference like when you know when to pick the right access mode, how how really make a difference? We see a list view that it was taking six minutes to take four seconds.

A

So that's a big big improvement and right here we have another example for a client that we have a few years back where josh and I we did some optimization and we have loading 65 thousand records with a lot of relationship with a lot of collections really fast, really insane, and we actually showed that we have another list view with like 56 records that it was taking longer longer is still acceptable, really fast, really thin, but it put you to think like.

A

If you know what you're doing you can't get really big uh loading up a records application loading really fast. So with that out of the way I'm gonna pass the control to dennis. He is going to present a few topics that we want to highlight about everything that is going on in staff right now, everything in some place or everything going on, and then we move from there. So then is I'm going to stop sharing my screen and you're free to start sharing. Yours.

C

C

Okay, can you see anything? Yes? Yes, okay, perfect. um I just wanted to highlight a few interesting links to documentation, updated knowledge, base, articles, examples and share some tips and tricks that may help you with xaf development.

C

So, let's start from the model, editor and dotnet 5 support.

C

As you probably know, we previously published a knowledge-based psychico about this topic and, as you know, the model editor is currently in a preview because we have not yet finished our improvements.

C

And it's currently supported for net core 3.1, but uh it's as you know, dotnet 5 was released recently and it's uh still possible to use the model editor, these net five applications, for example, with these blazer applications, and for this you just need a small trick.

C

If you go to the devexpress installation folder, you can find this runtimeconfig.json file and you can just make a small patch uh to it.

C

uh His the code and this patch will help you run the model editor for net five projects. For example. Here I have a blazer project. It targets targets.net five, as you can see, and I can now execute the model editor.

C

So I want to emphasize that dot net 5 itself. It requires uh visual studio, 16.8 and newer, so it will not work for 16.7 or something so be ready to update and be ready to use the model editor.

C

I also want to share that. We just that things basically work and we are just finishing our functional testing for all these scenarios, because there are thousands of them and we also uh want to work on on performance for the net of five version, because it still can be improved.

C

So, for example, here I have to wait some seconds, so it can be better um what else uh about the module model editor. I also wanted to share uh the information that we have fixed an issue in the recent update.

C

20.24 and this buckfix, it solves the problem that sometimes, when you invoked the model editor, some business objects could be missed. So please upgrade to the latest xf version and.

C

Experience a better model, editor.

C

Okay, let's continue about blazer. As you probably know, we have some new documentation and we we also have this knowledge knowledge-based article in our supper center. We updated almost every week because our tech writers create new interesting help topics. We also get updates from the support center. We also get updates from jose coche emmanuel, for example new videos.

C

You can see all these links here, for example, recently our tech writers added some interesting articles about accession property editors in detail view you can see how you can use this customize view item control, extension to access the model of blazer control and customize it in c-sharp.

C

There is also a new example for the grid control, similar approach.

C

You overwrite, the on view, controls created method and access required list, editor and updated properties. So it's all old goods xf.

C

Also, I want to encourage you to check these videos on hotch's, channel or host's channel, uh because guys, unless I'm mistaken, they upload new uh videos every week or every two weeks and this some interesting stuff.

C

um By the way, I forgot to share a link to this uh recent support center ticket about grid control customization. uh It shows uh how to customize total summaries using the approach I described earlier.

C

So you can, I o share all the links in the chat, so you can access them later.

C

What else here? I also want to.

C

Promote our team blog, we try to post a news every month here. You can see some interesting article about azure deployment.

C

There are also links to recent videos by jose hodger about electron.net, so feel free to follow our xav teamwork blog to get latest news about xavier.

C

Maybe some questions so far about these topics, maybe.

C

Okay: let's go.

C

This news is about the db, updater and blazer. uh Some of you might might have noticed that.

C

Gb updater is no longer used for for laser apps. We decided to simplify this process and now the application itself can update with database because it's a regular console application. After all, so you just take your blazer executable and pass parameters, as you did with db updater from the net framework.

C

We have published a new article on this, where you can can see complete information.

C

Now I wanted to share some interesting tricks and that I use myself when I code and they help me a lot every day and they help me in the past. The first trick is about learning through source code, microsoft, recently added their experimental feature to the release version of visual studio. It's this features it's about accessing the compiled sources of libraries, even if you don't have their source code at your hand, and it's helpful for learning.

C

uh For example, you are lazy to go to the devexpress source code or to microsoft source code, uh and you can just go to navigate to required source wire f12.

C

So I just go and press f12 and I can see all the sources, for example, in our new express, express, blazer library and it's helpful because you can see how we wrote our built-in editors controllers and you can learn new practices. You can compare your code with our code and maybe find some mistakes or best practices and, uh as I said, I use this feature every every day when I called.

C

Also, I wanted to share a link to to our support center when you submit a new ticket.

C

Let me wait. Internet is not good. Today, sorry, when you submit a new ticket and when you specify xaf.

C

We have added some tips and tricks that will help you get faster and more accurate responses from our support team. For example, if you face some error or your application crashed, you can click this link and uh it will navigate you to our popular article about uh collecting code, stacks uh error, messaging uh text and also log files, and this information is almost it's a must have for any error you you have, and it will help our support team and uh in many cases it will help you.

C

If you look at it, it will help you figure out what's wrong in your code, there is also a link to some ui customization uh chips.

C

uh This is also quite popular article uh where we explain uh uh who is for, and we also share some customization typical customization tasks and solutions, and we clarify required knowledge level.

C

Some give additional links to documentation, and here you can see just top the most popular customization tasks and figure out how to proceed with your own task.

C

There are, as you can see, there are links to some case studies from our customers who implemented some of these customizations.

C

So I hope you will find it uh helpful and the latest link is about performance tuning or troubleshooting. We have another popular article in the support center and it just contains typical cases and typical mistakes and solutions. So this stand-up is about performance. So we'll talk later about performance today.

C

Okay, any questions comments about this.

A

If you don't have it right now and you have it later, just put it on the chat and dennis or yourself we'll get to it.

C

Yeah yeah absolutely and some news for not about blazer um just uh for this one will be interested for our winforms of informs customers.

C

As you probably know, in 20.2 we have uh released a new asynchronous data loading mode for the grid list editor initially, and now. uh This mode is also supported for the chart list, editor and pivot greatly list editor.

C

The idea of this feature is that if you use the client data access mode, you can improve your application, improve experience of your new users by providing more smooth interactions with your forms. For example, if you use a data grid and you click record double click record to open detail view, it will show first, it will show a nice loading window, and editors will tell you you open smoothly.

C

It can be helpful for heavy heavy objects and this feature, as we probably know it can be configured in the model editor by setting a property.

C

What else also hey danny? I want.

A

On the chat they are asking, is there a single loading also planned for server mode.

C

For zero uh asynchronous serial modulin or what.

A

Gustavo feel free to.

E

Clarify it's a it's very useful for us to enable asynchronous data loading for server model view, because we use a not too much client mode because we have thousands of rows in every this view.

E

So we it's a must for us use server mode.

C

Yeah and I understand for such scenarios.

C

We have, uh as you know, we have a synchronous, uh server mode, it's called instant feedback and there is also uh another mode, instant feedback view and we have not planned to add additional modes to those through two. I.

E

I have a a few experience on using asynchronous server modes, but this uh it was a tool uh too slow. For me, it was a slow even compared with server mode. The asynchronous- I don't know the circle.

E

Is visually slow on the southern road? In my case,.

B

uh Can I I I suggest a a few interruptions here. I, of course, if you, if you add a synchronocity to the um living process, of course, there is some overhead, uh but over the less, the user experience should be better using instant feedback mode, especially if server mode uh is blocking.

B

So you can't speed up things that aren't speedupable or or are aren't that fast, because there are uh limitations of, of course, there's that to transfer all the all that kind of stuff, but the insta, the asynchronous load in xcf for the client access is just improving um the uh user experience, and this is the and that's the same thing with with uh instant uh feedback mode.

B

uh It's just data flows uh later in and ui draws, and I think there is no point in uh draw the ui first and then fetching data from server mode, because, especially that's that's the thing that instant feedback mode is trying to solve.

C

Yeah uh this, since the feedback mode is uh about user perception, uh and in your case I would recommend you try to test the instant feedback view. It's a how to say it's a server mode version of dataview, so maybe it will help you because you can specify only required properties. So it's a projection of your data, not entire object, so maybe it will help if it doesn't help feel free to contact our support, team and we'll see what we can do in your particular scenario.

C

Okay, uh my last uh item just uh can't help sharing it with you because for me it was looked like an interesting scenario. We have a customer who has the following situation. He has designed.

C

His security role and permission permissions on his machine and on his local database, and he faced faced a requirement to import this local data to his client database and he could not recompile his application to, for example, supply additional data in module updater.

C

As you probably know, we have a nice example that creates this module updater class automatically and this example didn't work for this customer and I just crafted a quickly a solution that allows a customer to dump his local data into xml file.

C

Then take this dump and send it to client and just import it from the client machine and save to the production database. uh It works with the help of xpo and memory datastore that allows you to save data into xml file and also then copy uh data into a real data store.

C

B

That's awesome, I I I use something like this all the time. This is such a time saver or it's like an anchor if you are in in mid of a project, and you need something like this and the client calls. This is gold.

C

Yeah and it's nice to hear and the customers, the customer also liked this option and he also further improved it according to his requirements. He, for example, unless and mistaken he uh he patched this xml file and removed data. He didn't need yeah, so check it out. Maybe it will work for you too.

C

Well, I think that's it once again. Thank you for your time. If you have any questions, I'm happy to transfer.

A

No thank you dennis for the presentation and for joining with us today to being here, so I'm going to stop your chair in for a second I'm going to share my screen and we'll go from there. Let me okay.

A

Okay, I think that I'm missing here, no, this one, okay, so a few things, and let me just pull up the chat, because there were a few questions on the chat. Are you gonna be able to see them as well? Just with me just one second,.

A

Okay, first thing a gustavo or anything else who asks a question: if we don't answer completely or if you still have doubt feel free to ask again or if not, as we say, reach out to us anytime, we are happy to go more in deep to go more.

A

To talk more about this, we love to talk about chat, so things that I want to say I really enjoy. Actually I have it here. If you see I have in one of my links here the example that then he was showing about exporting an important role, permission and runtime.

A

I think that there is a really neat solution there, and this is one of my to-do list to make a video about this, but I want to also encourage the community so every time that, because I I really love devexpress support, I really love devexpress controls and everything, but I also know that resources are limited. They cannot do a video, a visual of everything that they have.

A

They put an example and they have pretty great documentation and everything is getting if you see the documentation from play stories every time more, more rich, more is getting a lot better and we have more documentation. But I think that as a community, we should uh collaborate together and we should improve that as well.

A

So if you see one of these articles, you see one example, and you have some time and you want to taste it all, because if you already tested because you need it for your scenario, do a quick video do a quick article.

A

Article share it with the community, because that way, some people that are more visual, because, for example, here, unless you actually put this in your code and throw it and see, you don't know exactly what's happening, do it share it with the community that this article is actually in my in my to-do list to test it and show it to everyone how it works, because I think that that will really allow us to bring more people in the community to to chop everything that we have.

A

So please everyone who is here in the chat, everyone who is watching later, if you have to test for your company for your software. One of these examples that are already in the documentation do a video do an article. Let's share the knowledge with that.

A

Out of that, uh I want to say a few things about the whole presentation that denny has chose and again thanks danny the first one is really great to see about the model editor right now I was uh having a project in net5, but every time that I need to use the model, I was moving back to net core 3.1, so I can see the model and then, in that fire I wasn't able to see it. It's really nice to see that I now can use net 5 with a modulator, hey our next meetup.

A

We were planning. We are thinking of doing some. uh This is our idea. Those is soft, blazer ready for production. This is our next meetup topic, but if you guys have another one, please feel free to give suggestions. We want this to be an event for the community from the community and getting into the last thing that we are using.

A

uh Gustavo has a question on the chat as well and dennis.

A

This is for you so yeah I I I share these questions because, for example, myself, I am one of the the staffers who read the support center every day with my coffee in the morning, and sometimes I read, I have read the blazer faq two thousand times and it's true while he's saying, is there a way to know what is the new things that we add because a lot of time we are reading the whole article again to see if there is everything new and even sometimes we miss it, we don't know what is new.

A

There. Is there some time that we can know? What is the new change? I read it every week, but I I agree, maybe dennis we don't have an answer right now, but just something to think about it would be nice to for us to see what is the new addition. What is the new thing, because again, I'm reading.

C

A

And sometimes we don't know exactly what it had changed.

C

Yeah, I actually wanted to share my screen to answer because okay.

A

Let me stop quickly.

C

I prepared the answer.

A

All right, nice.

C

I'm not sure whether it's what you are looking for, but at least I want to share, as you know you can, uh you can, uh can you see.

A

C

We can see yeah yeah, you can go to our supper center and you can specify uh required products, for example, xf and xpo. Then you can also specify, like example, knowledge by the article and uh here it shows all the latest uh edits. So, for example,.

C

This article about model editor or this subject about server about logify and other articles. I know that some customers use this option very often and find helpful, for example, also to see known issues to save time.

B

I I use that all the time, um but the thing is I I think the question was: is there a way to see uh the differences between, um uh for example, uh uh the the the uh kb's and and and.

E

B

uh Between the last edit and the previous one.

C

No, unfortunately, no it's uh it's not supported for the supper center yeah. I understand what you mean now, yeah.

B

Yeah, I think that what I I think that was the question all right.

F

A

F

A

The question because again like I, have read the faq from blazer a lot of times, and I always I'm trying to see if there is anything new I go there and I say a blaze or a faq.

A

I open it. Okay, I should have not done that way. Blazer faq and it should sorry faq okay, it will put it there because I see it every day. Also, so I can start reading here. I know because I threw it every day, but, for example, if we add a new section like this one, I don't know this one.

A

I have to to to realize. Okay, this. I think that it wasn't. This wasn't there before. There is no clear indication. This was added and I understand that it's not bad again. That would be a nice to have not a must to have, but really a nice to have so.

A

Let me see, I think, that we have yeah.

C

I understand I understand, and uh currently we try to uh also also try to promote uh the most interesting uh topics uh in our teamwork in social media, and you know so. You can also follow.

E

C

Sources to get the latest news, yeah.

A

And I I have a friend danny who say that I don't follow you. I pursued you all the time. So it's like I'm trying to see everything that is going on new every time, but I have to agree with gustavo here that sometimes because I have read this so many times.

A

uh I I won't come back to this english that I see, for example, on the as you saw that updated a day ago, and then I come here and I'm trying to find okay, what was updated? What is the new thing? What is it's not clear? That's it, but that's it! That's nothing else. So, let's move forward, it's just a suggestion. If we can get something like that, it will be a nice.

A

I also want to talk about a electron dennis mentioned that that's a really nice choice and you can see the video I just have about showing electron mach on linux, on windows and I'm really excited about blazer blazer. I think that is the future, but not only that we are planning to do something like this for uh english.

A

But if you speak spanish, we have a couple videos about using mobile blazer binding and if we can dream a little bit in the future when play plays a web assembly is my mature enough that we can use our own stuff. I'm really excited about what we will be able to do with nadia's application. So jose thought nothing on the on the few months later in the next few months.

A

But it's a it's a great thing to think about like what we can do with those mobile blazer bindings about uh reading the soul, score and everything. So again, as I was telling you before, I encourage everyone. So if there is a new article like this on the place of performance, look up property editor that we didn't have a new action. We didn't he was loading all the records at the same time, or even this one about importing a role's permission.

A

Everything if you have to test it for your company, please make a video make an article, but my question I was here is freeing the so the source code pays so much. I want to show quickly a solution that we have here so there's.

B

There's one one thing I I just quickly want to to uh uh throw in here uh noxa, because uh martin made this ticket and we all know, there's the gdpr stuff and on that kind of with with uh regulations, and I hate those kind of regulations because, of course that express needs to lock down this uh the support center, especially for privacy reasons.

B

If you submit the ticket, please please for us: mvps, please make this ticket public.

B

They can't do it public by default because of law, but please do it public. I make every ticket public. If I can, if there.

F

Isn't confidential information in there, but please make the tickets public. I encourage you yeah, I suppose, support you. It's very.

C

Good point: I also ask people to make it public, yes, possible.

A

One thing that I want to add there I want just one thing: don't be afraid to ask a simple question: don't be afraid we are not here to say you don't know anything. We are here to learn together to support us each other. So I I read a tweet at once that it was say saying something: wrong is not the problem. Someone will and manuel have telling me have told me something hey. This is not the way to go. Go to this one. I don't take it personally fix it. I'm late.

A

I move forward what it cannot happen. If that you are being afraid of making a mistake, and you don't share your knowledge and you don't go out there. So don't worry about it. We are here to learn together. That's the only way join the community. We can work together. We can do things together, hey absolutely and jean-paul is asking on the chat. Can we win a prize for the most public tickets? You you talk to dennis about that they can. They can maybe put something together, but definitely take a polly ticket share.

A

Your knowledge learn in public. Don't be afraid, we are all here to help each other, not to like say I know more than you. I know less than you. It's not nothing like that. Again, it's just about working together and growing the ecosystem together. So hey quickly, we were talking about reading the source code. I just want to share quickly, and this will be just a second.

A

If you see here, we have a solution that it has the devexpress express, updates or project right there that we are referenced together. So we can see the code and everything, and if you see we have the lookup that didn't have a new action or anything and we were just playing and we put a button there, so we can actually create a new uh auction and put it in the lockup and everything.

A

So when you read the source code, when you see what's going on there and jose, can back me up on this, you can you can do your own things, even if the devexpress, because devexpress they need to make sure that their solution works for everyone, that they can support everyone that they can. But for us, if we need some specific case just for one a specific scenario: reading the soul code is so helpful because it gives you best practice. It gives you okay.

A

Maybe this is not ready right now, but we can do it ourselves and this example, for example. We won't share this solution because again there is already a custom property editor here that you can use that it has a new action. You can do a quick single selection, everything, so this is not or this should not be the way. But my point is: if you read the source code, you understand how everything is doing and you need it on your product before this official release, you can put things together and this is the perfect example.

A

If we see here, we have okay, we are not going to save anything. We have jose javier and if we see on our lookup, we have jose javier, but let's say we need another one. We need.

A

Manuel we can do it right away. That's the the the power, the free and the soul story, seeing how they're doing thing that you can try to to see. Okay, this is the best way of doing things and move forward.

A

Let's close this and let's not uh get too uh out of the way, because we want to do performance today. So let's discuss performance that that's the main point of today's and last things uh dennis talk about the the link of devexpress for newcomers.

A

I think that is in the end.

A

um Is something clue here? I think that I'm missing hey dennis. Maybe this is a suggestion. I don't think that is so uh discoverable now that I'm doing it right here. I think that it was.

C

Go uh to the top and to the right right.

A

Okay right here, I wanted to show this okay, we have that discussion about the shaft development is the middle between a completely from a scratched team of the better software developers and a codeless development like microsoft dynamics, or something like that and stuff gives us all the modules ready to go all the comfortable. But I just want to say that in the.

A

A

So I also want to say that we cover that specifically in the video that we did about overview about stuff and not only that for the spanish people, and I know that I'm like under spanish. I try to not never leave our community behind.

A

We also have that video here in spanish, so if you have someone asking should I use subscribe, please refer them to that link to the video on english to the video in spanish. Let's make them sure that they before making a decision, we have to develop their next line of english application. They have every uh requirements that they need every piece of information so with that out of the way, let's get into the topic of today performance.

A

So the first thing that I'm gonna do. I have two solutions here uh and of course quickly. Let's don't forget to watch all the videos that the community has support. That's uh provide to see the optimization doing so, but let's see a few things first things: let's talk about a data access mode and let's run this solution. The first thing that I want to show here in the updater.

A

We are using the bogus nougat package to provide fake data and we are doing if you see here, one million records and we already have in that database- 93 000. So let's run it for a second and let's see what we have here.

A

Let's do a quick demo of all the data access mode, so we know we used to when to use each one and josh manuel feel free to add anything when I'm showing this and then we are going to show like when we don't want to load all that at the same time, let's use xp view, let's xp query, let's see all of those and then manual will present the a n plus one problem. That is one of the biggest things on in the orm work.

A

So first thing that I want to say I went, we went to the app config and we had the xp03. So we can see the queries we want to see what is being generated by the framework. So right here we have our customer table and we have again we generated 1 million records and we had already 93 000. So we have 1 million 90 3000 records on this table. Let's close it out for a second, let's open.

A

If you see it's taking a little bit, there are a lot of records on the table.

A

So let's wait for it to finish the loading and then we discuss I'm not completely sure in which mode is this, but we will check it now. So let's go to the model and check what model what that access we had in there just to know. So if you say we have clients, so let's keep it on client and come back because we are having it on client. It's loading every record, everything that you have you have in that table at once, and I think that young palace, why should I use client mode?

A

We shouldn't use them right. Honestly, client mode works really great when you don't have 10 samsung records, so that's depending on scenario. There are applications that there are just not too many data, so client mode. It will be the default. I wouldn't change to any other data access mode and let your application start getting bigger. So there are those scenarios. So let's keep thinking about this, so we are in client mode right now.

A

Let's clear the console close this and open it again and guys uh today I have my daughter with me if you hear some coconut on songs, if you hear someone a disney music is my daughter that is outside listening playing or something so I apologize. But I don't really appreciate. I love my daughter. Let's keep going sorry. So if you see here, we open the listview and we have the query that we got executed. You see here we have one million.

A

Ninety three thousand, that is the queries, bringing everything from that record everything and if you see, let's say that I sold by address there is a small delay before things happening, so all those operations about sorting grouping they take time because they have to they. They need to go about the whole data say so, let's solve by name again. If you see it takes a little bit so when, when you're using client mode, you damn you know for sure that is loading every every trigger that you have on the other side.

A

So let's show now, for example, server mode and then is when we start seeing a interesting thing. So from now on, all the modes are loading that on demand and that's the most important part. You are just loading a set of your data and when you are scrolling, when you are sorting and then you are asking for more information, so we are in server mode right. Let's clear the console, let's close the listview and let's open.

A

If you see we have here, we are loading a few months as soon as we start scrolling. If you see the console, it start getting generating more and more queries. More and more queries is loading all the data on demand, but the thing about server mode. If you see one scrolling, it suddenly stop, because it's locking the ui until that data is not retrieving back, the ui is still locking. So again, let's do it let's pioneer and maybe now it loads too much.

A

But when I move you see, I cannot move this all the way down. It gets locked because it's locking the ui so server mode. He lost that on the mon on demand, but it locks the ui. So let's see the next one.

A

Okay, let's use now data view. The thing about data view is that data view loads everything on one query, but that review doesn't bring you the current object. It gives you a lightweight, read only a version of the object so and let's prove that, let's close this again, let's clear the console and let's open the customer, let's wait for it to load.

A

And remember: we have one million something records here. So if you see here, we have the query that bring everything just one query, but we also have this current object action when I click here and let's make sure that we have a breakpoint.

A

Okay, we have a breakpoint there when I click here and I select this current object. I click here. This current object.

A

If you see there is a data view that in this case, is xpo w because we're using xpo under the hood, but if it wasn't the or it was being an entity friend or that of you. So that means that we don't have the current object right here. We need to get the current object.

A

We do object, space get object and we pass that one and we will get it, but it's really fast and if you saw the video about the difference when we loading client when we loading in server and we're doing data view data view, for it was four seconds set, that was 40 seconds and a client was like six minutes. The thing is that you need to understand.

A

It's like you are not bringing the whole logic, so that comes with some consideration like you need to go and say: oh get, respect get off, get together, yeah you need to, but this is the important part you always have to design your rm. You always have do. I need to load all the data, or do I don't or do I give them a separate action to do that, so the data view gives you that really nice a way to do things, but it doesn't bring you the whole object.

A

So, let's proof now, for example, server view or instant feedback. Let's go all the way around. Instead, favor instant feedback is similar to server view, but to server, but it does asynchronously. If you see right here, we can move the ui, we can cancel, we can do anything and if you keep scrolling, you still are able to move and you are not locked, but the data is being loading. A background track is doing another thread, so your ui gets responsive.

A

Let me admit someone that it was waiting. So that's a server view is the same as server, but it's doing a synchronous way. So one thing that I want to add here: if you want to load data in a synchronous way, server view will be the fastest server view will be the actual this assistant feedback by a well. You have server server view is some feedback and some feedback view for the synchronous server view would be the fastest. So let's do server view. So we sure- because I thought that way was joining. Okay server.

A

View so server view server view loads everything's in chrome is good, but again it doesn't bring you the whole object. You read something that is called object record and if you need the object, you need to do a game object. Space get ok and last one.

A

Instant feedback.

A

View doing asynchronously, but if we click it also bring an object, regular, it doesn't bring a current object so few things that I want to say there first one client load everything at once. Application performance depends even if, in the hardware of the client, because everything is happening, it should have to load everything. It's definitely not suitable for more than 3000 records, or something like that because it actually, if you see salting grouping that takes time that lock the application.

A

So if we go to the other that access mode server and server view, they are loading data portions on demand, it locks the ui. So it does it doesn't report, it doesn't respond to user interactions and the operations happening on the server filtering and everything else. But I want to say server view because it brings you a light weight. Read-Only version of the object is the faster of the synchronous way now instant feedback and instant feedback view. That's the asynchronous that access mode, so they also load that on demand. They also bring everything.

A

So when you do pagination, it brings more, but instant feedback view brings a lightweight version of the object and again instant feedback view is the fastest fastest of the asynchronous way, and we have that of you that I like to say that it kind of flattens your object, because you just don't bring anything. Let's say that you have, I don't know, customer and department, the department doesn't bring the whole object, the default property of the department. You just bring the stream that you need to there. It doesn't bring everything else, so it really really.

A

It really does improve the performance so knowing when to use which accent mode, knowing what to use that really gives make a big difference in your in your application, and I know that, for example, in in the facebook group someone said yeah, but if you're not using client, you are losing some capability about a. I don't know some capability of the grid, about calculation, summary and so on, yeah, but no no customer would like to be waiting three minutes, five minutes to slow release view.

A

So you need to see every there is going to be everything always a trade-off, and if you want to load a another data that is in the collection, you can put it separate action that put it in a pop-up. If you want to listen summary, so there are a lot of ways around it that it doesn't have to be like that it doesn't have to be. I need to have client mode all the possibilities, all the real.

D

A

D

Sorry, I want to to add something here: sorry that.

A

D

Is that you really need to make a a distinction between if you're going to use a list view just to pick a record to open a detailed view or if you're going to use the listview for analysis that you need, like the column, chooser, summaries and stuff like that?

D

I think those are different scenarios, but most people confuse the idea of picking a record with analyzing data or you want both at the same time and as you said, you can put it like in a separate action to do something different to open a more complex view. But to pick a record, I think you need to get for me. That's my opinion, what it loads faster, because that's what the customer wants to see.

A

I want one thing that I will add here. One thing that I will add here is think about a list view with one million records. Do you think that the records that you need will love and will load in the 21st record? No, that won't happen. I can even give you an empty list view and allow you to search if you want, because again studio for you to find that record, it won't it's again in one million record the probability to each other, the one that you're looking for in the first one.

A

That's that's not so when so, when a client asked me, I want every field in the column, chooser. I want everything I said: do you really need it? Let's talk about this. What do you use every every day on your that's, what I'm going to put you on that list view. That's what I'm going to add you in the column choose it, but if you are only accessing this field once a month that shouldn't be there, you shouldn't be loading that every time you should have a separate action, you should have a separate algorithm.

A

Something like that. Hey jose, I'm not watching the chat, but if you please can do please be seen, and if someone is.

B

For this performance demos, what kind of process, uh how much ram? How much memory do you have in this machine.

A

So if we're talking about my machine.

B

Machine right now, yeah.

A

Okay, let's do a okay; let's do it and don't okay right here, let's see my computer properties, you can just open task manager, I guess yeah, but if we say we have i7 and that's very machine yeah, okay, yeah, nothing, crazy, nothing, crazy! I don't have an i9 with a big desktop with too many no and actually I'm pretty sure this application will run even with a I don't know with less strong. I don't think we need 32 gigabytes. I don't think that we need the last size seven or something like that.

A

That's just because we do so many uh angle. I we have been talking about that with horse a lot. uh I want to have the perfect development environment that is not even in my computer. That is just like a github code space like using a server, but we cannot do that for the emulators that we do a lot of summary applications so, but.

B

Fernando is is having a interesting comment here. The main difference in performance think we detect in the connection mode to the database with several connected users in memory calculations list here in cadaveria, without it on complex reports, blah blah blah the performance in the cloud database. Local database with 36 gigs of ram into the xeon excellent or network database, is very different.

B

Yes, it is, and that's that's the main reason why we need to do performance, testing and load testing.

A

The most important thing that I would say- and I think that it has been said- two million sign, but I would say one more: you need to test your application in the more close environment as your production environment and you have ways to do that right now. It's not like. I don't know how this is going to be. You have bogus. Do you want to generate millions of vehicles? You have to taste a big data loading. You have a easy taste.

A

You have unit test, you have test cafe, so you have all your tools so actually invest some time and make sure your application. When it gets big, you will be able to handle it and that's a really big important part. If you have, if you skip that part, there is a recipe for failure, because when things start getting a big and big and you have a client in real time asking you this is too slow. I have clients on my queue waiting for this.

A

You won't have the time to do this optimization. So please plan it beforehand, design your aim. Yes- and I think again- and maybe then it's from upon us for saying this, but I think that a staff gives too much that beginners think that, okay, if I just put a new class and new things, I do have all this functionality and then, when things start getting so we always say this to our students. Think about this.

A

If you have to do the query by hand, you, wouldn't you would you would tell the client, you don't need this. You will only give that the three phase that they need, but because right here we can give them everything and we can do invoice punto, customer punto country, punto continent, punto name. You have 200 million queries to the database because you didn't plan ahead and one that's one of the things. If you saw the video and jose do I like to see when we open a list view? Why are all these queries generated?

A

Is this query coming from the security system, in this case this query, coming from a controller that we are doing some weird thing? It's like, let's see, let's make sure, because, especially with databasing azure with remote databases, every trip to the database is a delay that you have it's something that you need to take account and we actually show that, for example, let's do a, maybe let me just continue.

A

We are right here and let's clear here.

G

A

G

Sorry question: I'm.

A

G

And thank you for you explain in this case, for example, uh in really application for performance when the user and 20 user connects in simultaneous comics is different performance and win user is uh 100 performance for the connection database and one user, use recurring queries and recruiting steward procedures and any load information recurring in reference scenario: states when the user need or file user uh between on difference, 20 and 25 users when they, when they use coding database, for example, um database sequential databasing clause is a slow connection and any performance is low.

G

A different and local database in the in the server hp with the process intel, 0 and 64 run. The performance total difference in more case is not for the error application and look for the error components. The express is necessary, refractory model database and then database stable database and clear index indexes for table.

A

For major performance in the division, let me let me give you my two cents and I will allow dennis manuel or roche to give their own, but I will say something about this: fernando. There are so many variables and what you say, for example. The first variable is a: are you using wind phones, because, if you're using wind forms it doesn't matter, every user has their own clients, so they are doing the processing in their computer and it's just the access to the database. Are you using wind phones and web phones are used in blazer?

A

Okay, that's the different things, because every user, the session is being so much memory. So many processing. So that's a different conversation, but not only that. Let me go a little more in that more in depth as your sql and if you saw one of the videos that we have give you the query performance, you need to have some. If you are talking about indexes, you need to do some maintenance in your database. So the things that you access most in you need to be indexed the thing that you actually have to use more.

A

They need to have that things. Are you loading more data that you should you shouldn't? Be loading all the data, so all those things taking consideration, so I I like to think about this stuff is not I want to pay the licenses. They will do a complete erp for me. I just have to do my logic. No, because there are too many variables, there is hardware. There is infrastructure. There is your code. How you implement it. There is actually just give you, in my opinion, best practices.

A

It gives you a a take care of all low tasks like a database creation database columns. They give you ui generation your data group models, your model grows. You have a little view list view lookup view it gives you so much, but you need to put the the last part. Have you hear this phrase that a software perks 90 percent of the time? Ninety percent of the project takes one month and that's ten percent to tune everything as you want takes a year?

A

It's something like that. It's like those fine tuning. You need to understand that you need to know how things stuff is doing things and you can definitely have really performance of application and you don't have to take care of all those low tasks and josh. Please uh yeah.

D

I wanted to add something that is a case that we get like really it's common case for us. I would say when the customers approach, they say like uh we have like two different scenarios. First, they say like we're using sql server express so in the database. There will be a limit for ram and cpu usage.

D

So that's why uh I suggest to most of the customers. I mean this is your preference, but if you're going to pick an open source database, maybe you should go with postgres, because postgres is not uh uh it's not a small version of the engine that you're getting you're getting the same engine that you will get if your pay, so, basically whatever you can do for to improve performance on a paid version of pulses, you can do it in a open source version, or at least most of the time.

D

That's one of the cases like uh you have the the bottleneck in in your infrastructure, not in your code, then we have another case that you have the the bottleneck of performance in your code and when you have it in your code, there is no amount of money that you can throw to the servers that will make it faster because we have some customers that they say like okay, we asked our client to buy a server for the database with 64 gigabytes of ram for 10 users, or something like that.

D

So you don't need as much if you write it in a good way. So it was a funny case because in that case uh the clients of our customer were spending more money on infrastructure than in their own software, because the code was reading not in a good way. So there is always a ways to fix it, but most of the time- and I really tell this to all of our students- uh I mean this is an answer that no one wants to hear.

D

But you need to take a look to your code and measure performance and just don't pull everything, and there is another another tip that I will do. Don't use xpo collection if you don't need it because, most of the time people assume that to get a collection of records, you need to get an xp collection. Yes,.

E

D

You can use an xp view. Sometimes you just need two fields from an object that contains 90 columns. So unless at least.

H

D

B

Show that later.

B

I think um the the main thing about performance that the desired part about performance is, it's always a balance and, as you said, jose, uh don't use an xp collection. um Yeah, don't use an xp collection in an hot path where performance matters most of the time. It's it's. It is easy, but you need to invest and think about uh performance, growth and and and and how performance relates to music to ux, for example, and uh I'm not sure uh uh um fabian.

B

Can we switch to my performance demo because I I think that really blends in into this category.

A

Right now, let's do something: let's do something manual. I will do the the demo that I have planned. It will be okay.

E

A

Then we jump to yours and then please keep track of every question on the chat. So we don't miss anyone and we'll come back to this one, because one thing that I want to show is again because.

B

Because I think uh the most part about performance is always the discussion. That's that's the right kind of thing to do all right.

A

Let's, let me run you my demo, you will run yours and then we'll go ahead. This course every question we, I already showed you all the that access mode. So I have another solution here that I just going to give some pointers about data loading. So, let's quickly clear the console, I always like to clear the console again. We have seen all the all the queries there.

A

Let's close our clear again and let's see: okay, let's open the orders, you see all the queries that got generated and if you see most of them, the first one are about a store password navigation state. Those are security systems. What we care about are the last one. We are bringing the product we're, bringing the order and so on. So we have a couple actions here about lazy loading, create collection, crease after review. I'm gonna run through all of those really quick just to do sharing action.

A

So again, let's clear here from here and let's click lazy loading. We click here. If you see here right here we're creating a collection type of product, nothing crazy, and if you see there is not even and let's make sure there is not even a query being generated so far, we are just creating the collection, have an access. Now.

A

What we want to show here, because the the action is called lazy loading is that lazy loading is the concept, the pattern that we're going to load every things when we need it until we don't need it we're going to defer the loading of that uh object or whatever. So we haven't touched the object. Now there is another query, but if you see here right now we're doing console gridline and we're touching we're touching that collection so right here there will be a query and we have another query. Another play point here: let's click continue.

A

You see there is a query that it goes to the product table and but we haven't touched the order and the order is in the product, but the collection of order hasn't been loaded. Yet it's just a query to the product table and if I click continue again, there is another query to approve, so you you can understand how staff is loading things. So if, in your list view is loading order and product is doing two queries to the database, so let's click continue and two at the.

B

Time so it's it's for every for every product and an additional query so.

A

It's the n-class one, it's loading all the orders and it's doing also a new query to the product. Yes, so that's those are two trips to the database. So let's do something quickly from the forward. I will close this. I will go to the order.

A

I will click. Take the the explicit loading attribute. What this is telling you is, please bring me the order and the product in just one query that way. You only do one trip to the database. So if we run this again and let's wait for this to load- and I will clear the console and do the same process again.

A

Okay, let's close this, let's close everything and if you know before it was doing two two queries when we opened the order listview. But if I open it now again, oh forget: if this is navigation instead roll. This is security system thing. Let's see the last one. If we go here to the last one and we check the from we see here, that is going to the order table and doing a left join to the product table. So it's bringing everything in just one query.

A

So if you know when to use those attributes when to load the data that you need, you can avoid a lot of trip to database that will actually save you on performance. So with that one we are already covering the explicit loading attribute, bring everything just once, let's keep going and let's see all the other methods that we have. Okay, we have create collection, create data view hbo.

A

Again, let's clear this, and now let's do calculation. Okay, again, if you see the output, there is no one query. We created the collection, the collection is here, it's a speculation, but even you say that is not loaded. You haven't touched it so when we click continue, that collection is doing console gridline to write the name of that product.

A

But if you see, let's see the query, it's doing a select to the id, the name, the description, the estimates is not filled the jesus record, the pro so everything that is on that product it will load. It will do the select completely so exp collection. What jose was saying before it brings you everything, every property that that collection has. So with that out of the way, let's see a few more things, let's say that you want to do data on demand. You don't want to load every property.

A

You don't need to have everything you just need to have a a minimized version. I just need the name. Maybe I don't? I just need the order counts. I need something, but I don't need everything so staff database and one important thing that I want to say here when we're saying xp collection that is xpo related. It's not if you're using entity framework, that's not foreign to the framework and to the friend.

A

We have another way of dealing with this, so I want to make sure what is the difference between something that is agnostic or something that is platform. It is only for xp or it's only foreign, for example.

D

Also, javier, you need to to highlight that that, if you use the object, space create create collection, I think is the name of the method. You will get an eye list, you will not get an xp collection or something from entity framework, it's an eye list which is a really primitive way of holding records together in general.

D

One thing that I want to say here.

A

We're talking about performance, not about data access. If we want to talk about that axis, I will always have a different exclusion, because the name the thing that I see, that is most a.

A

My opinion is amazing, is the object. Space object. Space has an eye okay, space interface that interacts the same way even if enter the framework xpo or even if you do a provider and you do hibernate or something so in this case, when you're doing a create data view. If this is xpo like this right now, I will bring if you see here against pio data record. But if you enter the framework, it will be something else. It's an agnostic way to handle to connect to your database.

A

But let's see this example, we are doing a great review. There is not even one query, let's clear here, nothing, but as soon as we touch that data view- and this data view is the same type of a processing that a soft dock does with the that access mode. For that of you right here, I only want the name and I want the order count. Nothing else.

A

If I click continue, you see here is doing bring me the name, and there is another select count from the order. So you can see that specifically, is not bringing anything else that what you are asking him to do. Okay, I just need this data and he only brings you that data. So that's a great way to only bring the error you need. So, let's click continue.

A

We did creation what you see that loads everything within data view there is agnostic way to bring different data. Let's do xp view, expect query xp. Those are specific to xp hpo, so again clear here, xp hpv right here. If you see all this is user name password. This is not related to the query. It's just a security system, and hopefully I think that after the next meet up, that is a south blazer is ready for production. We should do another one joseon security system, security system, yourself, security system outside yourself.

A

I think that is that's a great topic. I really enjoy that so right here we are creating a a object space of type of product and we're bringing the session we're, creating a new xp view, and if you see here we're telling them what are the properties that we want. We want the name, and we can even here have the certain direction. We want everything and then we can have those build records that only bring the property that we want. If we really continue look this query how beautiful it is is select name from product.

A

That's it. If you see there is a where this record is null because, of course it cannot be deferred area, but it's just telling you. I just need one property, bring me that one nothing else has been low loaded. So performance is being a big having a big boost when you don't have to load all those extra properties. So I like experience, but I will say my favorite- is the next one expect what let's do this you see here?

A

Look at this. We create a new hb query and we say from the product query. That is the word that we create. Just where done the number where the name is child, and let's see this for you one sec, just one. Second, you see it's saying a where name is shy right here and then let me see if I can, just where the name is shy, and this regular is not null when there is no deleted. Blame me, the name description ultimate is locking. This record is bringing everything so, but why is that?

A

Because we're doing selecting? So let's do one thing: let's stop for a second, let's uncomment this and let's comment this one. Instead of bringing the whole record, let's just bring in, let's just bring the name only the name and let's see the difference between this query, that is bringing name description, optimises, login register record everything from the product and, let's see when we are just bringing the name in that in that action we are just have a query that is completely different, completely different. Unless wait for it. Let's clear here.

A

Let's say expect: where look at this nothing. There has been a query yet, but if we click continue just name, there is no select name from proof where this record is null and name is chai, nothing. That is not bringing description. There is not bringing anything that you don't need. So I have to say: exp query is one of my favorites. You can actually- and you can also, if you're, seeing here, we're using the syntax of link.

A

So it's a really nice way to to actually only load the data that you need. So let's click continue and say: okay, we so view where the review collection- let's see south georgia, because this is the the other thing that I like. I am myself and jose. We are xpo. I don't know what is the the words fun boys we breathe and leave xpo. We don't use anything.

D

D

I think what by mistake? Okay, that's fine! Let's click mute regardless.

A

Again, I like, when community, when surfers, mute their microphone.

D

Javier fernando is asking oh sorry, someone else was talking.

A

Either way if someone else wants to talk, just mute, the microphone and, let us know, put a message on the chat, but I want to say it's like I myself, an hp all the way I use xpo on summary on web on windows everywhere. But again what I like about shaft is that it's not or a it doesn't have a favorite, so you can use a entity framework. You can do anything else and this, for example, the same thing that we show about xp of query.

A

If we use this one that we're going to use now and as always, let's clear the console- let's do object query if you see here we're using the object space that is diagnostic way to connect to the database query of product and right here we are creating a collection that is an eight whereabouts and there is not a query generated in the output. So, let's see when we actually go to the foreign and toss that one.

A

But before we do that, I want to say you see we're doing it where here we're using link and we can even go more in depth. We can do something like we did in the hp query we can do select here. Let me see the other complete we can do select and only bring the name. We can do the same thing that we showed before, but that's the beauty that we can use, link expression and we can only bring the data that we need. We don't need to bring anything.

A

So if we click again continue, look right now, we'll bring. If you see description, what the message look: everything because we're iterating the whole object, but if I here say select only the name, it will bring just the name, so it's a really efficient way to load that on demand. So let's click continue, and there are two last thing with preface and without preface that mean that, okay, before we saw the explicit loading, we want to load the order and the product just one query, but the thing about doing it.

A

This approach is that this is a hard code thing. Every time that you load the order, it will load the product as just one query, but let's say that we want to do it dynamically. We want to do it. Sometimes we want to load everything in one query. Sometimes we don't want to load everything on query. So that's what decision, prefetch common effect and let's hear in action so without prefetch, of course, of before so, let's clear.

A

So we have here, let's see it, we create a session, we create a collection of products, and I want to say something guys, and this is our mistake. This is my mistake right now that I'm presenting this never do this.

A

Just you have to put here type of and the type of a object space that you want to create that's the best practice, because sometimes uh they create your space, can mix and return a modular space. There is not the one that you need like a non-persistent object space answer, so you need to be specific of I want to get in with your space. There is type of product, so it can't return a hp object space. So again, I should have fixed this for this demo, but we are all human.

A

So please don't don't do as javier does do it. The right way don't be happier. Please don't be jose so uh right here. I will fix it right now, because I wanna I wanna get this quickly. I think that is we are going further. I manuel still have to do a demo. I want to discuss another link and we want to move this forward, but don't be happier do it the right way. Okay, now, let's clear here again right here in this point we have not a nothing, not even a query generated.

A

We created xp collection, but if we open it will say not loaded, nothing has happened so far. So if I click continue, we touch the product collection and it will do a query to the product. But you see there is not a query to the order. Yet because this is this is actually lazy. Loading in is is this is lazy loading exactly right here. If I click continue again, you go to the product and now it's going to the order.

A

So until you don't touch that object until you don't get to a part, you don't that's defining that loading. So let's do the last thing and I will move to manuel to the demo. So, let's clear again for the last time, and now, let's do it with a preface right here. If you see preface we create a session of type of product, we create the xp collection and then we have to create the another speculation for the products and then we say session class info. We let them know.

A

Where is the the collection that we want to load on that prefetch and then we do a preface and we pass the product collection, the order, collection and the memberif. But what I want to show here is like if we get here, let's see the last query, uh I think that it hasn't been generated yet right here. All this is a security system. Let's click continue, let's see the last one.

A

What I want to see is that, right now it's not doing us before that it was doing first order and then product right here is doing from order left join and it's bringing everything in just one query, and especially when you have remote databases, every trip to the database make a difference. So please plan for that. So.

B

It's basically telling xp all the same thing as the prefetch.

B

Not now that the attribute the explicit explicit load attribute is doing exactly.

A

Yes, the difference is like here. The explicit loading is a hard code attribute that is going to happen. Yes,.

B

Yeah yeah yeah, but.

A

That, basically you you.

B

You're, giving the session a hint, please uh preload this record as a lecturer or a inner join, or something like this.

A

B

Get it in one in in one one round trick to the the base.

A

Okay, so hey I don't wanna. I extend this folder, I'm gonna stop the application. I I if we can see, we saw xp view expect wearing software view. We saw that access mode. We saw lazy loading. So what I want to do now- and let's just be quickly here- we saw all of this and I'm gonna pass now the control to manuel. So he can talk about the fixing, the n plus one problem, but before we get to that quickly, I forgot to say that every link that then is shown this presentation.

A

You can also see here. So if also here.

D

We have a question in the chat um from fernando is: there is a way to get that solution from soft data access. Definitely.

A

Definitely I will put it online, so everyone here can access it, but again dennis can share his presentation as well, but if not, you have every link that he talked about here about how to receive the modulated or net 5. The.

A

If you see here the support center, how you can see that it has some suggestions on the top and so on. So I'm moving a little fast and we're gonna get to every question on the chat, but I want manuel to present his solution and want to also talk about this before we go this article and they've expressed about how to improve a measure. Application performance is really important, so I don't want to lift it up without getting to there. So manuel, I'm gonna put a little bit of pressure on you, but please no.

B

No, no, no, no, no! No! No! No! No pressure at all.

B

I ever set my timer for five minutes, because you all almost covered everything I want to say anyway, so I I I'm going to do a quick presentation for five minutes uh and then uh we can get into fewer answers than it's like 15 minutes or something so, okay, let's start okay, um I need to share my screen. Go very quick.

B

uh I need to share my whole screen. I'm not sure I have no idea okay, so um I did this uh presentation a couple of um months ago. It's it's on my github, it's on github! uh I have no idea, let's think about it's like uh xpo, no idea! No! No! No! No here here is the source code for anyone.

B

It's like fixing an n plus one proof problem in excel fx build. So there is the source code. I am running it more or less pure basic metal and it's just a a sample application with some.

B

With the same ideas and concepts and and and and kind of uh um um solutions going, why is your application slow? How you're attacking those problems in the next effort? Xpo application?

B

I am not uh focusing on entity framework right now. It's just xpo, but basically the concepts are the same. So um I have a lot of uh a couple of demos uh as javier showed earlier, there's just a sub, a couple of controllers that generates data and to make sure everything everybody is on the um knows how powerful this machine is. This is just a um surface book two, I guess or three two.

B

So it's a i7 six hundred with two megapixel gigabyte gigabyte gigahertz. So it's not not a uh all four palm of powerful machine. It has some ram, but it's not a it's just a notebook. It's not nothing, really, really really um um expensive or something like this.

B

So um the only thing I want to to talk about against uh uh uh to to um all the stuff uh xavier told before, because my demos are basically pretty much the same so there's this there's all the kind of stuff like clients or remote data view blah blah blah blah blah blah.

B

But the thing is: um there's a main difference between perspective performance and actual performance, and there is a main differentiation between um where is uh where are: are the performance of the lacks of an application most of the time when people, and that it's getting me back uh to the one of the first questions? It's like uh what is the ux? What does the user experience uh about if somebody is telling you an xlf application, is slow.

B

The source code is online, so there's a lot of different options. You can configure your application, but the main thing is: why are people thinking applications are slow and I think the main reason why people think applications are slower. Unresponsive is the first, the first time to interact, so um it doesn't matter how fast your application is.

B

It only matters how fast your application feels it. It is a psychological feeling, so um your your application can load in half a second and people will process pursue it as slow, and you can't do anything about it, because people are like uh we have like 300 300 milliseconds.

B

That was five minutes no way. I think that was okay, uh but the main problem is um people think your application is slow if it feels slow.

A

Does the alarm for the five minutes ring.

B

Yeah, I I I I I can't think it was five minutes, but okay come on come on, yeah, okay, so uh real, quick, uh there's all kind of options, everything in in the nxf application. Everything uh throw me in. Let's start with the slow offer. That's what that's the dumbest thing. You can do it's like five seconds and it's slowly, 40 000 records and now 300 records, and but afterwards it's it's. It's all in memory. It's super fast, okay, uh there's the different technique. There's the link technique.

B

Okay, gets getting getting better, better and better and better- and I will minimize my screen right here and what this is doing is like. uh It should uh uh uh calculate some um um thumbs up. So, okay, we have all the slower slopes and further faster options, but everything I'm clicking is really really really slow.

B

So I'm clicking here and I'm thinking and waiting and waiting and waiting and waiting and waiting and waiting and waiting and waiting and waiting and waiting and waiting- and I think it's like loading hundreds of thousands of records- and this is a local database, so that that's not.

A

B

A

You're doing this, nothing.

B

B

Okay, there it is better yeah, yeah, yeah. Okay. Sorry, I'm sorry, I'm sorry, I'm sorry, but that that's a that's a bit. That's there's a whole application, so it's all the options that uh xavier talked about, but there's a client serving blah blah and, and the thing is that is not a huge application uh and there's the client server model and and all that kind of stuff and it's loading and loading and loading and loading and loading and loading loading, but um there's one controller in there that measures just the performance of refresh.

B

So if I press the refresh button, uh it will refresh from the data source and I get an accurate or more or less accurate measurement from uh from the database. It's like 500 records or fifty thousand five hundred thousand records.

B

It's like loading in seven seconds and of course that is a problem, uh but let's switch to a faster view: mode, for example, uh data view and now it's more or less instant and it's like loading 500 000 records in 100 in in in 200 milliseconds, and the question we get asked before was like uh um the perception about feedback about how fast uh uis are. Are built up so if I click on data view, it's like more or less.

B

Instead, if I click on server mode, there is a delay, because uh the ui and all the locking and all that kind of stuff, but uh the performance difference is almost magic global. So if you look at my blog post, there is all the um figures about how how this sample is produced and how all the queries are produced and all the timings and stuff like this. So uh it should be horrible sauce if you, if you follow through all that kind of stuff, but the thing is about perception.

B

uh Server mode takes a little bit of time, but, uh as you can see, it also takes time to uh sort things, for example, because there are no indexes on the database tables so that there you can't calculate anything in uh uh in memory. If you do server mode, hey.

A

Manuel, please uh let everyone knows that it's important the database part the database maintenance data. Yes,.

B

Yes, and and that's the thing I'm going to so uh those are the old ones. Those are the new ones and nothing is a silver bullet. Your database needs to know how you want to access your data. There is no way you can sort and filter everything in milliseconds, except you spend hundreds and hundreds and hundreds of times of computing hours or insert speed, or something like this.

B

If you, you need to set a performance goal and that's the main main thing you have to think about, but if people say xf applications feel slow, it's more or less because uh they are laggy so like in the server mode it takes like 150 milliseconds until the page shows up. But if you compare this, for example, with the data view, it's like okay, there's, a small delay that every record in this whole row or in this whole database. It's like 500 000 records.

B

It's like loaded vertically, every record one by one, but the hard part is done by the database. If you do really really uh interesting um triggers and um calculations or indexes in the data table in the database, this would be as fast as uh like in seconds and now we get to the instant feedback mode. Now we are, this is client mode. This is really taking eight seconds or ten slow, slow, slow, slow, slow, slow, slow, slow, slow, okay, every record was loaded.

B

I have no idea, like massive amounts of ram right now talk, but I took him for the application. I have no idea like hundreds of megabytes, I have really no idea, but it's like okay, it's like 300 megabytes, only for one table and now the same thing exactly the same configuration, but it's instant feedback, and now, just all the records get loaded by uh on demand, but one at the time and in the client mode. So those two are like prints, client and instant feedback are like twins.

B

The only difference is like this one is like: okay, it works, but the user doesn't see the data. Any uh questions so far. Are there any any uh something I have to slow down on.

A

No don't slow down, yes, okay, everyone wants a question please they have to reach out later on. You can put it on the chat okay, but I already want to get. I still want to write to the the express article about how to measure and improve performance. Yes before. Let me let me interrupt you for a second.

A

It will be just 30 seconds. I want to say a thank you for everyone who is here in the chat and I'm seeing the chat right now, and I recognize almost everyone- and I want to say thank you for being here and I want to again. I won't stop saying this encouraging everyone, gustavo genesis, fernando david, adam, hey everyone, every time that you're doing something that you think that is really cool. Put it public. Put it online.

A

Put it there, let's make let's break all those myths that there are you already breaks, have ui is not customizable. Today, we're gonna break that the performance and, let's break everything, and I have my my microphone on and because I'm talking but my what my my point is here, my daughter is screaming out of his lungs. So I hear and listen to her if you guys hear that that's my thought here, so I cannot do nothing about it. I love her. She when she say something I have to comply so sorry about that.

A

Keep going please! I'm gonna put myself a mute so that doesn't bother anyone.

B

Okay, so uh let's let's make until eight and then we will jump to questions uh there's just one thing: that's like the instant feedback view and the data view. There are also twins. So the data viewer is like. Okay, uh let's load all the data. That is visible, so do the hour ring. Do the name: do the calculation, do it in the database site and come just load every record we have so it's like a select sum plus thing: name wow.

B

It's like with the uh with the exp query the style that that that jose showed uh before. But there is also the instant feedback view. It's basically the same thing, but it's like asynchronous, so the ui gets thrown up. So we know there are that. Let's do that again, because there are like the ui is speed up, there's everything here and there and and we need to recalculate on the database and that will know, add a lot of load on the database.

B

But it's like really smooth from from a user perspective and just to show you that is that that isn't just a trick. uh If I do recalculations like 240 seconds or something like uh uh under 200 milliseconds, and if I do the instant feedback view, I I'm below 70 milliseconds before I get the first uh line of uh data from the database.

B

So it's like a.

B

It focuses on the ui's perspective, so this is the the kind of perceptional um uh way of performance. It isn't faster in any way. It's just deferring the hard calculations. So this is like okay, it's here.

B

It's click it's here and there is the server view and the server view is like selecting this kind of uh window out of out of um all the data. It's like making a a a cut of all the data you want to show and also uh need to calculate on the server.

B

So it's super fast, but it's not uh asynchronously, and I think there is a async server view.

B

I have no idea if that there is, but most of the time um eastern feedback view. It's saying that real, so those who are are uh uh are clones so.

A

Right now, let's, let's think about this client but.

B

It does it doesn't matter, but the thing is: it depends on the data load you have so and if you, if nothing works, if nothing works for, because you have too much uh too complicated structure or something like this go with normal procedures go with database views with secures blah blah blah blah blah. There is a lot of fun.

A

That's one thing that I want to emphasize or to highlight, and I will let josh get to that, but database views store procedures all are being able to you can handle that with xpo. So yes and xpo and spirit find all the way down. So if someone wants to talk about entry framework, it has to be someone else, but for myself that I like spo, we can handle execute query, execute non-query, execute the stored procedure. Everything that you need. You can map your data view to your persistent object and I want to say this.

A

My then I saw a question on the chat that I say how middle time we can affect performance and so on. So today we're talking about performance, but next meet up. I I would like to build something like I want to answer that question, that a lot of suffering is asking us, is soft place or ready for production, but that will be the next one, but we have so many more after that. We can do another one.

A

After that there is security testing and we can go over all the security system. We can do another, one that is accessing software and non-stop app and we're going to talk about a web service. We want to talk about wcf, we're going to talk about xpo api, we're going to talk about the new, a web service that devexpress is providing right now that I think that is really cool. Hey.

A

We can talk about graphql that we did a really nice example a lot of things so, but this one specifically when I talk about performance emanuel, uh please er, sorry dude interrupt you! I will let you continue, but after that I want to definitely go over the how to measure performance improvement, because I think that this is a really nice article that we cannot miss this meetup.

A

I know that we are already in the two hours a frame, but if we are able- and please everyone help me with this in the next 30 minutes- to close everything that we have- we are good to go. I and josh. I still I want to give him some time to go over the article about how to measure in profits. So please manually.

D

And have three.

D

But in general there was good question. I just wanted to to say it, so everyone knows about it and is how middle tier can affect performance.

D

Maybe we will not cover that in this video because we're running out of time, but we uh with manuel like often so I guess that's a topic that we need to write down to yeah for people who use middle class.

A

We'll do another meet up that is accessing soft data in non-soft app and we'll talk about the middle entire web service. So manuel, you have three minutes, uh I'm sorry, okay, but I will do if you don't. Okay, let.

B

That are the last performance tricks. Those are the really that don't everything about above here is like building you. That's just you don't need to worry. You just switch about the data access nodes and you have to think about the performance impact uh in different ways. Is it like click to first access, or is it like? uh Okay, I have to do really really really heavy stuff, and now you have to think it's like the um uh uh do. I have to really really do heavy calculations not 12 hours and do it under 30 minutes.

B

But that's that's what uh they said to um uh in star trek here you have the the um as you call the warp engine is broken and you have 30 minutes to repair it yeah, but you have limits and now you, if things really really get tricky and you have to really do hard calculations or to need to hyper optimize some list, you can go the normal c sharp route, but there's nothing special about it.

B

So you can do cqrs or you can use, and I will show views first because views is just using your database right. Have you do let the viewer do the hard job uh map it to a table?

B

Do whatever you want to do the inner join and the sum and all the kind of stuff, as you would do normal in in sql map it to a table and then go and just map the columns.

B

So I didn't map it explicitly, but normally this is like faster of a review. It's like uh faster off of review. Query! Okay! Is this a different one? Okay, but the you get idea map this thing to a database view, and now you are ready to go and it's like instant and it's instant.

B

It's like 100, milliseconds, 100 milliseconds and it's lower than uh the data view for its. For some extent, it's like half of the time.

B

So uh you can map to arbitrary views, although all the data is shown the same and the hardest one- and I really wouldn't recommend this, but I would recommend this to a client that uh spent 24 hours to calculate some calculations.

B

You go with the cqrs route, so normalize your tables. So uh if I look at the secrets, we think- and this is not a best practice- it's just showing how to re-sum some of the uh connecting two tables together. There are better ways to do it, but it's the cheapest way with cqrs, for example, is like uh instant because it's like 11 million milliseconds, because the data is stored uh differently between clary and um and command. So the data gets replicated multiple times.

B

It is time it's easy because there's just a primary key and the name and the hours and the sum. So it's pretty calculated it's like an index, but you have full control over over the index and two more minutes. Last but not least, that's the the thing uh where uh the session prefetch thing is going on and the totally unsupported uh way of doing things.

B

I have no idea where I put my marker.

A

B

A

And how to rise by then, is to mute everyone after five minutes.

B

Yeah so last call is like the totally unsupported thing is that the n plus and inquiry is like uh fetching everything in one query and in the client and then re calculating it on the um on the uh faster offer. Let's take a look and using the session like a a property bag to store uh cash data, so it's per every row we have here.

B

Normally there would be one additional query and we do all the query at the ones all the sums at once and it's like the best way of two walls is like the client mode, but without having to recalculate every row once at the time. We let the database do its job and just cache the data for the actual usage and then use the id of every record. So every record here has a primary id and then we do the calculation.

B

We do two queries. So, let's see, if we can uh look at that real quick view, output, press output there- it is, I hope there is uh yeah. Okay, let's do a refresh.

B

I hope that works, and now you can see we do two sec, uh two separate queries, but those are two separate queries and those get merged into one uh calculation on the client. So it's super fast, but it doesn't.

B

If you have to to really have a calculation that may might be an offer. Okay, that's it for now. If you have any questions about performance, improvements feel free. Let me know by email or twitter or something like this.

A

Yeah, please use it on facebook and linkedin.

B

A

Like this, oh you contact manuel or.

B

On github, especially on this sample, especially on the github you can can every sample I use is uh every blog post. Has the sources linked so or just that uh uh issue right here, little brand new troubles.

A

Okay, so hey, so we well a little bit out of time, but we're going I'm going to do like 10 to 50 more minutes. uh So uh the the last thing that we want to talk about the performance today- and this is a really important.

A

So if you see your, we have all the topics that then is already highlighted, but we also have the these two blog posts, the the one that manuel show about the fixing, the oneplus problem, but we have this one, and I think that this one is one of the biggest one that we need to talk before we we finish the meeting and because this one gives you profiling tools. This will give you a general advice.

A

It will give you anything that you need if your application is actually having performance problems, so I I will allow jose to talk a little bit about this and he can walk me through to go over but primos. This is our generals uh recommendations when you need to profile your application when you need to message the application performance.

A

One thing that I want to say before we move forward is, I know in our in our uh suffer weekly. I say that we have a big surprise to the end and the surprise is simple: martin praxmer is here with us.

A

He joined the community, stand up he's really busy right now, because he has a little migration ruling on his side, but I want to say that his software he has 900 companies that are using it right now, so there is at least that I know anyone that has a bigger clientele that the biggest performance a experience for asking questions about performance. So he will be on the chat. Please everyone, if you have any question whatsoever, feel free to ask him. He will be happy. He dennis manuel jose to answer any question that you have.

A

Please don't let this opportunity pass, because my thing is always really busy. So I'm really happy to at least having on the chat. Please asking any questions asking anything. We still have like 10 minutes, 15 minutes to go over about these articles before we call it a day. But again, I always think I have said that to manuel to hoshi today, a lot of time. I wish that I won when I was starting.

A

I have this place this opportunity for the community to get together and ask this question as oh, I'm having this issue and having this problem, and I guarantee you one of us at some point of our career. It has hit the wall in that thing and they this same problem.

A

The the the opportunity that we're offering right now is not that we are better than you is that that we have hit our head on the wall more time than you trying this nothing else it's not about. We are better it's just about in household we say that what I'm offering you is like. I tried this two million times and I hit my head on the wall.

A

To be honest, I I couldn't make it work until I could and when I cool I can avoid someone else, some new beginners to have the same road that they don't know how to do something, and we are happy to be able to be of assistance and happy, and that's why I always tell everybody: join the community. Let's work together, let's cover collaborate where we can learn faster, so without moving a. We are getting too in deep on that route. uh Jose.

A

If you want you and I we can discuss this article- uh please everyone who is on the chat- please thanks martin to be here and if you have any questions about performance. This is the moment because there can not be anyone who has more than 900 companies using their software that have no deal into any corner case about performance, so again, house you want to start.

D

Yeah, um let's go down javier with the to the first one I mean to the list, and that is really important, actually, that the application behaves slow when you're trying to load some views that you never know before um this happened to me this week. Actually, that's why I want to highlight this point: is that the runtime is not loading every time.

D

It's not everything at the beginning, it goes little by little and you can see that when you do when you use the repo viewer or the report designer that it will take some time, the first time to load. So in this case, this problem is not related to saf or xpo is how the dotnet framework works. So you need to be able to distinguish what I mean.

D

What is responsibility of debt express and what is just microsoft in general and what is your responsibility? I think the best the the best way to see it. So I have never done this. I mean the answer for that, but I think that you have done it before javier, that you can uh recompile to have native performance, that you don't use the intermediate code in general. So if someone is having this problem uh in general, is this is related to the dotnet framework? So is there something that you want to add there.

A

No, I think that you would say oh jose and definitely when they. I think that this is a really great article. If you read all the way through it tells you about. There are so many pieces, so many uh parts of your application that you need to take a account for like this. You can you can when we say about about the profiler, the xpo provider, that is just profiling, your xpo code, that is generating the queries, but you also need to provide your sql server. You also need to see your logs.

A

You also need to see, if you see this article, this article is really good. As time passed, your application will need some database maintenance law. So it's like you want to have a staff to be the the superhero that does say everything it does enough for you, it's in your a in your side to do the last part to make sure that the index is creating that if the everything else is going created, because again, there is no way to to pray.

A

I don't know how to say that if there is no way that we can know how your business, how your application requirements, so it's up to you to know, depending of your application requirements, you can do everything else so again. This is a great article that we can see like. These are the the the recommended, javier.

D

Something happened to your microphone. We can barely hear you.

A

Okay, sorry about that, let me let me know: if can you hear me yeah, it's better! I don't know my headphones are not acting dry. So please also continue sorry.

D

A

uh Scroll down and let's.

D

Go to the ones I mean, I want to talk the ones that we face sometimes, and the 1.3 is the another one that it happened to me in the past.

D

Maybe you have seen my videos where I talk about the salvadorian electricity company, and that was one of the cases there that we in that case we had a web forms application like software in that case, and we left the log on and we were low in everything.

D

So the application became like really really really slow and also the files were huge. So we got a call from from the it guy in that company and said like what is your application doing? That is creating so many files, and it's because we have the log on in in the more detailed level.

D

So once you go into production, I will strongly suggest that you should turn that off unless you're having an error, if you're having an error, turn it on, because most people cannot tell you how to replicate the error and in the log you can see. Actually what will happen? I mean the log. If you can really read it, it will be like a timeline of what happened.

D

What was loaded and actually is almost, I would say, almost as good as replicating the problem in the studio so but don't have use of it, especially if you're having web applications where it's just one instance all the users are in that instance and you're creating several files, because the application will go slow. I mean, will slow down a lot, and I tell you because that happened to me before.

A

Hijack, can you hear me well now.

D

No, it's the same, I mean you're, I mean it looks like you're like far away. It seems like you're far far away.

D

No, no now it's better now.

A

But yeah all right. If you can hear me there are google questions that if I was a suffer, I would say I say to martin: hey martin with 900 companies that you are supporting are using winforms. Are you using one phone? How much are you using blazer? I will ask hey. How is the performance wise? I will ask uh what roblox have you encountered? What can we do better? Please there is. This is not something that we can do every day. We have martin right here today. He's really busy ask questions. Please continue jose.

A

I just want to say yeah.

D

uh Okay, so there was, there is another one that I want to talk about is one 1.6 and yes, that's I mean you should try to avoid um checking the permissions too much in the security system, because if I mean, if sometimes people tell you like, okay, uh let's restrict everything, but you really need to make sure like how that will impact performance, because, with with you, javier, we have done this before, like uh sometimes there are some stuff that are not needed and you can really improve your queries if you check your security system permission so that I think, for me, is a must, but the thing is that this is complicated.

D

I mean because most people want a map. I should do this exactly. This is the recipe yeah. We can have somehow like a recipe, but you still need to take care of your own main problems in like what is your performance neck, because sometimes we have in another case- uh and it's also here in the list- is, I think, 1.7.

D

That sometimes it's also your network, it depends on the type of application you're doing what we did in el salvador, most of the time where applications for the government. So in that case we could not tell like okay. This is your network or whatever, but in some I mean in some cases your database will be remote, even if it's within the same building or whatever. So you really need to make sure that you up your your network is performing good, for example, uh most of the customers that we have in el salvador.

D

They use oracle and when you are using oracle, you usually make sure that when you're doing the fine tuning that, if your dns is resolving good and how long it's taking your dns to resolve to the name server, that is another measurement that you can uh check and then try to reduce. But again it will depend on your scenario. Most people don't have this scenario remote database or so on. Most people using one building one room.

B

That's the thing with that performance goal: you have to set the performance goal and you have to check what are the performance goals and where are the the bottom legs or uh try to identify the performance of that yeah.

B

As I said um in in in south america, there, the internet connection is sometimes uh slow or reliable, uh then don't be chatty, don't use chatty protocols, don't do hundreds of of of of requests to the same database and then try to to squish down uh the the amounts of calls to the server in to a minimum amount and and and and get better performance out of uh being uh doing, one request getting everything I need or or the other way around.

B

If you have a really really stable connection, really really focus, you should focus on um good user experience anyway, like with instant feedback mode and stuff like this. But uh if internet connection isn't reliable, then you need to think about strategies, and then it isn't about performance.

B

Most of the time, if you talk about performance is like oh database is low, no most of the times database isn't slow. Most of the time we, as developers aren't focusing on the real user experience and on the real goals also.

A

Especially azure and jose, and I will have an example using software- I was mentioning.

E

A

And we did a couple tests and we thought like we need to get a in actual. You can choose the the tire that you're paying for you can use things and we, like exactly our client, told us like. We need to show this demo tomorrow tomorrow. So, okay are you showing tomorrow we put everything to the highest biggest database, tire biggest app service tire. We did everything they did their demo and it was great. Everyone was happy the other day. I said we cannot keep paying for this uh processing, so we lowered everything down.

A

So look at think about this. I lowered the database to the free version to the to the lower commodity, and I used the absolute which one that it was decent. It was not the higher and it was working perfectly so the bottom leg. It was not the database, it was the app service. So again, it's all about testing. I cannot give you a recipe that tells you hey. This is how you have to do it you need to. There is.

B

A

B

Secret one really really really secret, never never ever to use your full capacity of your development machine to perceive any kind of testing.

B

If you do this, you always gonna be in pain, because your machine is likely to be 10 to 100 times faster than your client's machine. So don't rely on your perspective, perception on any.

A

Kind of application, I will tell you something else: do you know this a everybody knows, I'm saying, do you know, of course you know uh the mobile blazer bindings project. That is experience experimental right now, so I've been working with that a lot and everybody everyone asked. How ready is this complete and I always respond? What do you want to do? Maybe this is complete for you? Maybe it's not, but there are.

E

A

In the app store and apple is a big, I don't know a big feature that you can say if it goes to apple it because it's complete because it gives you a lot of yeah. So what is complete for you? So if somebody asking me right now and their express will say no, it's not this in the preview is stealing, but we have productions. uh Applications in soft places right now, so that's depending on what you need to achieve, sometimes yeah.

A

The reason it's not ready, because we need to get to this part that isn't, but for some other applications is ready, and we will prove that in the next meetup. But my question my my point here is the performance. A soft laser, a mobile blazer binding, is a it's all about perception. What do you need and we can give you an answer? There is no recipe that tell you hey, you are good to go. You are right, is.

B

Is is xf ready, 400, concurrent users out of the box, sure? Is it ready for a thousand users yeah? You need.

A

To say you you need you need to you, can you leave they? Can you only say that they cannot say that because yeah.

E

B

Listen to many.

A

Things, but I can say that I.

B

B

And take your brain and say: okay, here's the hot path; and now we have to.

D

Optimize, there is one thing that I always tell my customers, and I mean our customers in general. Is that if you cannot figure it out, we won't be able to figure it out. I mean if you cannot understand the pain where you're having your bottleneck in performance and also don't start throwing money at it beforehand, because people say like no: let's buy a new server yeah, you spend like ten thousand dollars on the new server and the performance is even worse.

D

Why? Because you need to really make sure or understand your application, your code and also it depends if you're coding for general purposes- or you know the case where you're going to face like.

B

For the internet there is no silver.

D

Bullet there is yeah, so in that case it's like you, don't need to only think about your code. You need to think about. How is your pro? I mean, what is your production environment and how much you understand your production environment and one thing that javier just said that for me, it is amazing is like how ready is for you yeah. So it also depends on your qualifications. Somehow, because, for example, javier asked me like one when we decided to go on production with blazer, it's like.

D

Do you think that we're ready and I said like well, we check all the source from developer, express we get the the blazer module, we see it each code, I mean.

E

D

One and then I told him like well, I think we can do it. I mean they have their code.

A

D

A

Say to jose is, of course, depending on what we're trying to achieve is if it's not too crazy, but if it's under the the borders, I say I'm happy with it. We have them expressed if we run through any.

E

A

We have them to to help us off to see what is the best way to go. So I'm happy with that and one thing that I will say because I have seen in the chat that they are not taking advantage of martin being here. This is my question for martin simple, you just said yes or no martin.

A

You have 900 plus companies using you, your erp, using staff. If you have to come back and start from scratch, will you you suff again? That's the only question that is yes or no. Will you come back and use the same framework use the same thing that it has allowed you to get to that point with seven developers it starts with just one developer, and now there are seven: will you come back and use the same framework? Yes or no? That's the only question.

A

Martin feel free to put it on the chat. That's it and yes, please everyone who is watching the meetup go to this ticket. This ticket is really nice and I remember the first time that I read it. I saw that this is really. I don't understand anything that is going on here. I will be honest.

D

uh I think here that we need to use that article for the next meet that we have with manuel, because I mean yeah the next switch, because this can go really deep and it will take three more hours. Yeah.

B

I think we should.

D

We should do.

B

A whole uh a workshop on that.

D

Yeah, because a lot.

B

D

Like we can say from experience uh like I said like for the being I mean you need to check your network stuff like that, but all of those are different scenarios really different scenarios and most of the time are not even related to code.

D

How you decide your idea in general. So with that I mean, if someone come with okay, my application is slow, that's the title of the email, but then you need to figure out. Why I mean if they cannot tell you, then it's a different question that you have. Is that you don't understand your application or you don't understand your code in general, so I think, like we should put that manual on the on the back border yeah. I think that.

A

Next meetup should be it's a blazer ready for production. Then we can do a security system, then we can do accessing stuff from node and soft application, and so on so on so before we go. I just want to say this quickly. A martin answered, of course. Definitely why would you have if I have to do a big erp for 900 plus company, but I want to show this before we go used to.

A

We have a video that you can see it on my blog about the soft performance, but let's hear here real quick and we can call it a day. Please everyone. If you have any question about today, can we.

B

Can we get some uh uh 1 000 subscribers, that's for next time say today: can we have some 1 000 subscribers ads for the next meeting.

B

It's one month, so it's the 10th of of january.

B

2021 and now we should get, we should have hats, so I.

A

B

A

Would you have had to have beers which you have it's a big party.

H

A

Because I don't know you guys, but I enjoy this, actually, we me and jose. We schedule our second thousands of every month as a vacation day. We don't work, we don't do we don't do a meeting. We don't take. Any one email today is for taking a.

E

A

Vacation, I know we have a weird vacation concert, but we really enjoyed this. So thank you, everyone who shows up every every thursday to get this conversation- and I don't want to make this a longer, because it's two hours, two hours and a half and that's alone.

A

I just want to show this because I don't want a people think that we're making this is the solution. I just run it and, as you have here, we can click entity 65000 records. We see all the relationships that have all of these art collections. All of this at reference property is really fast. If we open, for example, this one it even takes longer, and it's only 56, so I I will have to say, let's open it again, you see how fast I would have to see. We did a lot of crazy things.

A

Maybe even dennis or devexpress are not happy with us, but we deactivated secure the system. Member formation, we actually deactivated a audit trail with the activated version controller, a compatibility check. We did a lot of things, but we make sure that when I click new there is not even one query that when I open the list view, everything is going less close quickly. If I open the listview- and I go to the queries again, let's check for from let's make from everything yeah, let's see. If I can see it.

D

Here we have, we have a fernando said what a beautiful windows form custom application and that's true. Why didn't we show that in the other.

A

I don't know why they would enjoy it, but I was just want to show it that I don't see it here, because maybe I have a few drinks guys. This is not coffee, but my question was like I want to show here. Let me see: okay, I've seen that we passed it here. You see this from he's doing entity that is the name of the class left join location left join country. Let's join uh autonomous community. This is spanish but left viewing everything. Everything is coming in just one query.

A

So if you know what you're doing staff can be freely performance and not only that just.

E

Can take care of.

A

Ui can take your database. You just need to know how stuff is doing things and tune it to your specific requirements. So guys guys think about this. You can have your erp, your biggest application, think about marketing saving the payload seven developers doing an erp for 900 plus companies, so more than 500 companies. So I don't have to say anything else. I'm happy to be here and happy to discuss in this I'm on vacation today. Thank you for being here and that's all for me.

A

If anyone wants to add anything, please do it, but I'm done.

B

Thanks for joining uh for hosting and jose thanks for joining as well and dennis as well, I hope you're not uh uh totally snowed up and not uh in total, uh covet isolation right now. So.

D

Yeah guys take care and I guess we will see you guys in the next meetup.

C

D

C

Thank you very much.

A

D

A

Martin, thank you, martin, for showing up thank.

D

You martin for turning here.

A

Thanks everyone who chose ups, I always say I'm really grateful for everyone who gets thursday. Whatever time is in your side of the world, to talk with us about technology and about stuff, that is what we enjoy and again uh we even if we finish the meetup right now, dennis manuel jose, martin myself, everyone. We are always happy to answer any questions. Please reach out to us. Please, post a question on the reader. Please post a question on the facebook on linkedin: let's grow the community!

A

That's the only way that we can ensure that the friends that we work, that we love gets better and better and better as he's doing right now, blazer is the future. Everybody don't forget our back. Okay, thank you. Bye guys take care.

D

A

D