Knowledgebase
[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

Problem Description

      I have an 800MB DataFlex table with several million records and I am trying to delete them all. What I need is 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 yield similar results. The database is on my local machine which is 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 one by one in a DataFlex program it would also take forever. You should be using the DataFlex DFFILE utility or the Visual DataFlex Database Builder utility to create new tables.

     Visual DataFlex Personal "Personal" is a new, 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 same operating specifications as a commercial license Users must register and provide contact details to get an activation code. The product is delivered in time-limited form - registration and activation remove time limit to create a perpetual license Only for private, personal, 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 invocation of the Studio and Client Engine.

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 created 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.

     Learn more about Visual DataFlex commercial licenses.

     Click here to Get Visual DataFlex Personal!

(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).