Ludicrous Speed

BLOMASKY

For anyone who is not familiar with the term “Ludicrous Speed”, close your computer and go watch a copy of “Space Balls”!

Or, as Tom Cruise said in Top Gun: "I have the need... The need for SPEED!"

Now that we are talking about speed, some questions, since an application is never TOO fast.

1) System Settings has memory options for Aware IM Server, Tomcat and configuration tool. What are the optimum choices. (Assuming running on a server that has lots of RAM.

2) SQL Indexes. I am using MS SQL for my system. I notice I can create indexed attributes in Aware, but they are only for a single attribute. Assuming my application will query (or filter) on 2 or more attributes, and there are lots of rows, and I create the multi-segment index in SQL, can I assume this will speed up queries, or does Aware force “hints” to the underlying DB

3) What server to run on? Forgetting the cost factor (yes, a Linux server can be much cheaper than a windows box), Since Aware uses JDBC drivers to connect to the backend database, can I expect similar performance on either a Linux, Windows or OS X Server?

4) Talking about OSX, I am developing on a mac and have seen some “flaky” behavior in the configuration tool. It seems like running Aware on Windows 10 (under Parallels) seems a tad more stable. Can anyone share their experiences with OSX and Windows for development

Thanks

Bruce

BenHayat

Regarding # 2 and Indexes.
Each attribute can be flagged as INDEXED, but you can't make multi-segment index in Aware.

It's the job of SQL engine to take advantage of an index on a particular Column (attribute in Aware), and not Aware system. When Aware creates an SQL statement, the SQL engine will use an Index if it's there on it's own decision.

Secondly, for multi-segment (Or composite) Index, you can go to your SQL Management system and create one, BUT, if you make a change in Aware and Aware has to do Structural change you may loose that Composite index. The best time to create it, is after you app is completed and you go live, then create those composite changes. Next time when you do an app update to server with DB Changes, then check those composite Indexes.

customaware

Bruce,

I started out development on the Mac flavour and now use Windows version under parallels. Is fine.
Use MS-SQL Express for development
Aware IM Server 512
Tomcat 1024
Config Tool 768

Everyone is likely to recommend different values but certainly the more resources you can allocate the faster it is.
I read some people have multi Gb memory allocations on there systems but I dont need that yet.

I deploy on Amazon's Web Services and have instances in Frankfurt, Singapore and Oregon. Mine are not load intensive at the moment but all works great.

There are a wide variety of different setups people have including Mac hosted, various hosting options and a myriad of configuration options.

My pea sized brain starts to hurt when I get to close to this stuff.

ACDC

If I am not mistaken, the max memory size utilization of the free version of MS SQL is 1GB , so depending on how large your database is this could be a bottleneck as DISK access speed becomes an issue. If you were using MySql I would suggest setting the "innodb_buffer_pool_size" to almost the same size as your database . This will speed things up dramatically

Obviously allocating sufficient memory to AwareIM and Tomcat is key. The best way is to pick a number and see how your app behaves by monitoring the process and how much of the memory allocation is being used and then continue adjusting memory size until you have enough headroom in place. (If you find you keep filling up the memory allocation then something is up with the rules in your app.)

I am not a fan of a virtualized environment and find running on bare metal is more efficient

Once the above has been sorted then " very selectively" using indexes bearing in mind that AwareIM automatically creates its own indexes on ID and single references on the object .

Lastly , as much as AwareIM takes care of the Database and does a lot of things for you , the design, layout and normalization of your application still needs to be carefully thought out - but I think you already know that

ACDC

forgot to mention , where possible in the rules on the Object check the box " DO NOT CHECK REFERRED OBJECT" otherwise rules of referred objects run unnecessarily

BenHayat

ACDC wrote
forgot to mention , where possible in the rules on the Object check the box " DO NOT CHECK REFERRED OBJECT" otherwise rules of referred objects run unnecessarily

Nice Tony!