The golden rule of optimization: Optimize only the slow stuff; leave the rest alone.

The golden rule of optimization for database applications: Always develop database applications using a database populated with real data.

Here comes trouble. If you're developing a replacement application, chances are you can get your data from the legacy system. If you're creating a new application - there is no data. But you need data to test and profile your application.

With the "Advanced Data Generator" tools from Upscene Productions, you have a powerful tool at your fingertips.

• Generate random data
• Use custom data from files
• Many supported datatypes, including BLOBs
• Auto-arrange table order when foreign keys are available
• Save your "data generator projects" and re-use them
• Large data repository with real-life data
• User defined presets for faster project creation
• Fast! Up to thousands of rows per second
• Generic ODBC & ADO or database specific connectivity
• Generate data to the database, INSERT script, CSV, YAML or XML file