Jump to content

Search the Community

Showing results for tags 'optimization'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 17
    • FileMaker Server 16
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker DataAPI
    • FileMaker WebDirect
    • Custom Web Publishing
  • FileMaker Platform
    • FileMaker Pro Advanced 17
    • FileMaker Pro 16
    • Command Line Data Migration Tool
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • Brain Food
    • Legacy FileMaker Platform Discussions
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Member Lounge
  • FileMaker Friday Night Chat's Topics

Blogs

There are no results to display.

There are no results to display.

Categories

  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Site Donations
  • Site Advertising

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Title


Industry


Location


Interests


Website URL


Skype


MSN


Yahoo


OS Version

Found 8 results

  1. I have a database that we use to update our website inventory. A few years ago we began offering customized merchandise that gets dropshipped direct from suppliers. Suppliers give us data feed files with their inventory levels, pricing, etc. and this file manipulates the data. It takes our current web database, compares values and exports those products with their updated values. Importing the data and exporting used to take less than hour but now it takes several since the size of the web database has grown and the number of suppliers has grown. Everything is automated through scripts. In the main table (web database), the proposed quantities, pricing, leadtime, variations, etc. all use unstored calculated fields to determine the new value. I then have a separate field which is used to flag items that need updating. The major bottleneck of the entire process is the searching of this field. It can take sometimes over an hour to search this field. Other steps like exporting the changes can take a while, too. I have done some things to optimize the database but it still seems that these unstored calc fields are what is dragging everything down. I have tried replacing some of those calc fields with text/num fields with "replace field contents" script steps (or auto entry) but it does not seem to make a difference because of the indexing. The database is not hosted or shared and my computer has decent specs with an SSD HD. I've got a simplified design chart attached for reference. I am not sure that this is what comes with a large complex database file or if my design is flawed. The only two things I can think to try to reduce the processing time is: 1) Rewrite the scripts to update the supplier/inventory table records instead of replacing the records fresh each time. 2) Use a looped set field script to set the "change flag" field and/or the other updated price/qty/etc fields Any thoughts or advice is much appreciated.
  2. I noticed that one of the articles updated in the official FileMaker Knowledge Base on September 23, 2011 was explaining how to select a random set of records in a FileMaker database. I was wondering how fast the currently recommended technique is and whether Ican make it faster with the help of FM Bench. I tried to apply it to a set of 50,000 records of randomly generated data. Then I made it much faster… Read more at honza.24uSoftware.com
  3. FOR IMMEDIATE RELEASE 24U Software releases 24U Toolbox Plug-In 1.1.1 Toolbox of the most useful simple functions for FileMaker® Pro adding precise timestamps, application-wide globals, and more... now also for server-side scripts and web publishing Prague, CZ -- September 27, 2011 24U Software announces an immediate availability of 24U Toolbox Plug-In 1.1.1 for FileMaker Pro 11. The new version of 24U Toolbox Plug-In has been updated to run in FileMaker Pro 11 on the most recent versions of Mac OS X and Windows. It also sports new useful functions and capability to be used as a server plug-in for server-side scripts and web publishing on FileMaker Server and FileMaker Server Advanced. What's new in version 1.1.1: - Application-wide globals let developers shared variables between FileMaker files - Precise timestamps allow for measuring of time with microsecond precision - Value type checking can be used to check data type of values passed to calculations - Auto Update savvy version function simplifies automated deployment and updates - Server-side functionality helps creating powerful server-side scripts and web solutions Other Features include: - Execute system scripts (Bash, Perl, PHP, Python, AppleScript, BAT, VBS) - Execute SQL on the current database - Count and substitute text using Regular Expression patterns - Find out which special windows (Script Debugger, Data Viewer) are open - Merge fields and variables into text (faster than using Substitute) - Get the client's public IP address Use 24U Toolbox Plug-In to add a completely new dimension to your server-side data processing Server-side scripts can be efficiently used with FileMaker Server 11 for nightly batch data imports and processing. The powerful features of 24U Toolbox Plug-in let you make this processing much faster and more powerful by being able to use system-level scripts, access your data with SQL queries, merging fields and variables into text, etc. HOnza Koudelka, Software Division Manager of 24U, says: "For a customer project I need to download data from several websites, import the data into a FileMaker database, parse the HTML, and extract thousands of records from the imported data every day. I am using Toolbox Plug-In to trigger curl to download the web pages, SimpleFile to import the downloaded files, and then Toolbox Plug-In again to help with fast parsing and preprocessing of the data. The text merging feature of Toolbox lets me even recognize graphical symbols such as smilies and translate them to text equivalents." 24U Toolbox Plug-In is designed to help FileMaker developers in their daily work by providing a solid toolbox of the most commonly needed simple but powerful functions. Requirements and Compatibility 24U Toolbox Plug-In 1.1.1 requires Mac OS X 10.4 or newer and FileMaker Pro 8.5 or newer. Recommended is Mac OS X 10.6 Snow Leopard and FileMaker Pro 11 Advanced. Windows XP SP3 and FileMaker Pro 8.5 are minimum requirements for using the plug-in on the Windows platform. Windows 7 and FileMaker Pro 11 Advanced are recommended. Some features of the plug-in are specifically designed for FileMaker Pro 8.5 and 9 and do not work with newer versions of FileMaker Pro. Availability and Pricing 24U Toolbox Plug-In is immediately available for download as a free fully functional 14-days trial version, which can be activated after purchasing a license code. More info: http://www.24uSoftware.com/Toolbox Download: http://www.24usoftwa...oolbox#download License for 1 user is $48, additional users pay just $24 or less! Developer license starts at $349 US limited to 20 concurrent users per site, but unlimited to a number of solutions or customers. Server-side license is available for $499 US and covers unlimited server-side scripts and unlimited web users seved by a single installation of FileMaker Server or FileMaker Server Advanced. To purchase visit: http://www.24usoftware.com/Toolbox#buy More about 24U licenses: http://www.24usoftwa...om/licenseguide Discounts are available to FBA, FileMaker TechNet, and FMPUG members. 24U Software offers solutions for people, not for computers! With FileMaker experience reaching back into the early 90's and developing FileMaker plug-ins since 1997, 24U has become recognized a key vendor of plug-ins for FileMaker Pro. Dedicated to creating the easiest to use FileMaker plug-ins... Optimizing performance of FileMaker solutions... Inventing unique iOS applications… Helping organizations to get more out of their technologies... We connect the dare of education with the experience of industry to achieve the impossible. Customer contact: HOnza Koudelka Software Division Manager, 24U s.r.o. FileMaker 8, 10, 11 Certified Developer FileMaker Business Alliance Member mailto:sales@24usoftware.com http://www.24usoftware.com Press Contact: mailto:pr@24uSoftware.com ###
  4. The second example I was showing in my session Marvelous Optimizations at Pause On Error [x] London 2011 was the script for selecting Random Set of Records. I found this example in the FileMaker Knowledge Base and optimized it to run at least 158 times faster when selecting 10 random records out of 50,000. This version of the example has FM Bench Detective script steps included to measure the original and the optimized script more precisely. Watch the video recorded at Pause On Error below to learn more details about this optimization. Read more and download the sample file at honza.24uSoftware.com
  5. Last September I wrote an article about a custom function that I optimized to evaluate hundreds times faster. At the end of the article, I challenged my readers and myself by claiming that the already optimized custom function can be optimized even further. Do you remember? Later on I actually really optimized it again, and talked about this optimization during my session at Pause On Error [x] London 2011. Now you can watch the video of this part of my session below: Read more and download my updated sample file at honza.24uSoftware.com.
  6. the Otter

    Search for Formatting

    Okay… here’s a toughy. I’ve got a corrupt file, so we need to get all the data into a clone of a known-good backup. Obviously I can import it directly, but to be absolutely certain we’re getting rid of all corruption, my supervisor has requested that I export the data to merge files and then re-import it into the known-good clone, which sounds great to me. Unfortunately, there’s a snag: a lot of the data includes formatted text, which is very important to maintain. So, here’s the solution I came up with, repeated for each table in the solution: 1) Export all modification information (mod account, mod timestamp, etc.) to a merge file. 2) Loop through each field of each record of the current table and check for formatted text, using the following calculation: GetAsCSS ( GetField ( $FieldName ) ) ≠ GetAsCSS ( TextFormatRemove ( GetField ( $FieldName ) ) ) Any data that returns True is replaced with its CSS equivalent. 3) Export the data to a second merge file. 4) Import the data from the second merge file into the backup. 5) Perform step 2 in reverse, using a slightly modified version of Christopher Gauntt’s CSStoFMText custom function. 6) Import the modification info from the first merge file into the backup. I’ve gotten the script to the point where it’s working perfectly, but it’s taking forever: it’s been running step 2 on a particular table (62 fields, 2.3 million records) for over 12 hours and is still only about 60% complete. Once it’s done, it still has to run the remaining four steps on that table (I expect step 5 to take as long), then process the remaining 33 tables (most of which are smaller, but still). Any thoughts on what I can do to optimize this further? Perhaps some method of finding formatted text? Thanks!
  7. This is the first example I was showing in my session Marvelous Optimizations at Pause On Error [x] London 2011. I already wrote about this optimization some time ago. It’s the one that led me to unveil the Marvelous Optimization Formula. You can find the original article here: FileMaker Script Execution Time Cut From 5 Hours To 6 Seconds I simply took the example and added FM Bench Detective into it to be able to exactly measure and examine what happens in the slow and the optimized script. Now you can watch the result in this video recorded at Pause On Error. Read more and download the sample file at honza.24uSoftware.com
  8. Prague, CZ -- December 5, 2011 -- 24U Software announces an immediate availability of 24U FM Bench Detective 1.0.2 for FileMaker Pro 11. 24U FM Bench Detective is an open solution designed to help FileMaker developers easily add precise benchmarking to their solution. With the help of this tool developers can measure performance of their scripts, calculations, and other parts of their solutions, and optimize them for better performance. FM Bench Detective is a free part of the new product being developed by 24U to address the need for optimizing performance of not only FileMaker solutions but also companies using them. What's new in version 1.0.2: - Internal global variables renamed to prevent naming conflicts - Timestamps are now logged in the host's time rather then client's time to ensure consistency - 24U Toolbox Plug-In 1.1.2 now correctly returns local time instead of always returning GMT+2 24U FM Bench Detective lets FileMaker developers: - Precisely measure execution time of their scripts and calculations - Quickly add measuring code to any existing solution - Store all measurements in a simple FileMaker database for further processing - Differentiate collected data by username, IP address, or software/hardware configuration - Use a single point to control benchmarking level or completely disable benchmarking Use 24U FM Bench Detective to better understand your code There is no magical solution that will take your code and optimize it. It's still you, the developer, who's responsible for the quality and performance of your solutions. But it's difficult to intelligently decide how to implement whatever feature you are thinking of just now if you don't know what to expect from the technology you're using. 24U FM Bench Detective lets you easily measure your code execution time with microsecond precision, so that you exactly understand which operations take longer to process. Only that way you can base your decisions on true knowledge instead of guessing. Since the first version of 24U FM Bench Detective has been released, many FileMake developers started to optimize their solutions. Steve Sanders commented on the 24U FM Bench Detective's website: "I keep track of my Custom Functions in a database. When a Custom Function is revised, I compare some “Sample In” results to previous “Sample out” results to see if I have caused an error during the revision. I also want to compare the execute times to the previous revision. That lets me know if I have optimized or slowed down the Custom Function. I used to use “Extra Suites” on the Mac for this but it was very cumbersome as I had to find and remove my own overhead. I could only get an approximate overhead value. FM Bench will be ideal to re-implement this in a clean manner." Serious developers have always cared about the performance of their solutions. But it took them too much effort to actually measure the performance of everything so they did that mostly only when issues appeared. 24U FM Bench Detective makes developers' dreams come true. Now you can base your decision on exact measurements and it does not take more than just a few clicks to add the measuring code to your solution. 24U FM Bench Detective 1.0.2 is immediately available for download from the 24U FM Bench website upon free registration. More info: http://FMBench.com/detective This announcement is intentionally brief to not bother members of this mailing list who are not interested in detailed information. To read complete Press Releases, please visit the following page: http://www.24usoftware.com/pr 24U Software offers solutions for people, not for computers! -- HOnza Koudelka Software Division Manager, 24U s.r.o. FileMaker 8 Certified Developer FileMaker Business Alliance Member mailto:sales@24usoftware.com http://www.24usoftware.com ###
×

Important Information

By using this site, you agree to our Terms of Use.