Lesson of the Day

"We learn something new everyday!" As a tribute to this saying...

We have this large million of records table. An audit table exists to record every single update or deletion of a row in this table. We were thinking of creating an index on this audit table where no indexes existed before. However, every update/deletion would require an update of this new index, therefore, slowing the performance of write operations on this table.

Lesson of the Day: Indexes, although improves the performance of read operations, leads to more overheard if this table is often updated.

I know i'm dumb..

Flex Error: ReferenceError: Error #1065

This error often refers to missing assets in the swf file that is expected to be there. For example, if you get the following error:

Variable ExampleView__embed_mxml__assets_png_example_picture_png_1012766830 is not defined.

It refers to a missing asset in an mxml file called ExampleView attempting to reference a png file as in the VBox below:

<mx:VBox backgroundImage="@Embed(source='/assets/png/example_picture.png')" width="100%"

In this instance, you must remember to include these assets into the compiled swf files.

Flash Global Security Settings: Windows vs. Macs

There seems to be a slight difference between how global security settings are set on Windows and Macs browsers. To note, when you set the global security settings, they are set "globally" for the machine and not for the particular browser where the security setting was set.

On Macs, you can just specify the swf file in the global security settings. The swf file will load successfully and any external interface registered functions can be successfully called.

On Windows, however, specifying the swf file in the global security settings will allow the swf file to load correctly. But, this does not allow registered external interface functions to be called. It will cause the following js error:

Error calling method on NPObject! [plugin exception: Error in Actionscript. Use a try/catch block to find error.].

In order for external interface functions to be called, you must also specify the folder/file where the swf file is located.

CVS Commands

Creating a New Tag from an Existing Tag
cvs -d :ext:{user}@{host}:/{cvs directory} -q rtag -r {existing tag} {new tag} {cvs directory}