Knowledgebase: Others
[QODBC-Desktop] Delete Operation Very Slow in DataFlex
Posted by Juliet (QODBC Support) on 03 June 2010 07:31 AM

Troubleshooting: Delete Operation Very Slow in DataFlex

Note: VB Demo is deprecated.

Please refer to How to use the QODBC Test Tool for testing

Problem Description

      I have an 800MB DataFlex table with several million records, and I am trying to delete them all. I need an empty version of the table, and since FlexODBC doesn't support table creation, I am trying to delete the records in a copy of the table. I used the C++ Demo program with the query "DELETE FROM mytablename" which ran for about 15 hours, after which only about 100,000 records had been deleted. Using the VB Demo program and MS Access yielded similar results. The database is on my local machine, a Dual Core machine with 1GB of RAM. Why is this operation so slow, and is there anything I can do to speed it up?

Solutions

     If I were to delete all the records in a big table in a DataFlex program one by one, it would also take forever. You should use the DataFlex DFFILE utility or the Visual DataFlex Database Builder utility to create new tables.

     Visual DataFlex Personal "Personal" is a unique, no-cost version of Visual DataFlex licensed for private, personal use only. Visual DataFlex Personal helps developers get acquainted with the product without making a financial commitment Provides a free, fast & easy development tool for non-commercial use.

     We believe so strongly that you will be thrilled with the power, efficiency, productivity, and capability of Visual DataFlex that if you try it, you will decide to use it personally or commercially. As a Visual DataFlex Personal user, all we ask is that you register your license and activate it upon installation. The license is perpetual (not time-limited) and free.

Visual DataFlex Personal definition

     A fully functional Visual DataFlex Studio license with the exact operating specifications as a commercial license Users must register and provide contact details to get an activation code. The product is delivered in a time-limited form - registration and activation remove the time limit to create a perpetual license Only for private, personal, and non-commercial use. Includes 3-user Client Engine Includes Connectivity Kits for MS-SQL, DB2, Pervasive SQL, and ODBC. Includes Personal Web Application Server Product logo screen displays on each Studio and Client Engine invocation.

Personal license - what's allowed?

     Development and personal use of applications Freeware distribution of your applications to others for private, personal use only (Freeware distribution may not be the basis of the creation of any form of revenue for application Personal-created software including fee-based shareware or paid programming services). Educational use in not-for-profit classroom environments (high schools, colleges, and universities).

Personal license - what's not allowed?

     Development and/or use of Personal applications in a business, governmental or institutional environment. Any form of revenue derivation, dependent transaction, or sale of software created with a Personal license (including fee-based shareware), Business use of applications built with a Personal license, Administrative use of applications created with a Personal license by educational institutions.

Support for Visual DataFlex Personal

     You can receive free online peer support through our Visual DataFlex Newsgroup at news://news.DataAccess.com/Visual-DataFlex.

Terms & Conditions - VDF Personal

     The Visual DataFlex Personal License Agreement is the sole reference defining the use and usage restrictions for Visual DataFlex Personal.

     Click here to Get Visual DataFlex Personal! Learn more about Visual DataFlex commercial licenses.

     

(105 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please complete the captcha below (we use this to prevent automated submissions).