Performance increase when using case-insensitive queries with Symfony, Propel and PostgreSQL

Posted by Eric Bartels

Symfony makes heavy use of Propel. Propel finds objects in the storage container using criteria. If you want to let Propel (okay the database) ignore the case you can set this in the criteria. $c = new Criteria ();   // Allow case sensitive searches $c->setIgnoreCase (true);   // Find all posts which name contains [...]

[Reminder] Disable output-buffering when sending a download to the browser

Posted by Eric Bartels

If you want to “send a file” to the browser (even if you do it in chunks) and your output-buffering is on you will get a fatal error when having large files. Fatal error: Allowed memory size of 0815 bytes exhausted It makes sense. The data of the file gets buffered. And after a while [...]

Bessere Performance unter Oracle-Forms 6i

Posted by Sven Thämar

Allgemein Um eine optimale Performance unter Oracle Forms 6i (auch höher) zu erzielen, ist es sinnvoll, den Source-Code von Triggern in Prozeduren oder/und in Packages zu hinterlegen. Bleibt der Source-Code im Trigger enthalten, ist festzustellen, dass die CPU jedesmal mit dem Parsen des Codes beschäftigt ist. Dies ist besonders dann kritisch, wenn zum Beispiel bei [...]

[Reminder] How-to add a custom usercontrol with the SharePoint Designer

Posted by Eric Bartels

Open the desired page (e.g. DispForm.aspx) with the SharePoint Designer and add the following code below the initial “<%@ statements”: <%@ Register TagPrefix="MyNamePrefix" TagName="MyNameForTheControl" Src="~/_controltemplates/MyCustomControls/MyCurrentlyUsedControl.ascx" %> Now add this code where the control should appear in the final rendered page: <MyNamePrefix:MyNameForTheControl ID="MyNameForTheControl" runat="server" /> Thats it! Of course your user control must be placed in [...]

Incredible performance increase with very large lists via “QuickView-Method”

Posted by Eric Bartels

Preface One of my SharePoint projects contains a (still growing) list with currently more than 230,000 items. These items represent positions of a quotation. So one “quotation-item” references multiple “position-items” (1:n relation). In order to have a user-friendly user interface I developed a custom webpart which allows a quick way of editing the positions of [...]