Member Login

Username
Password
Forget Password
New Sign Up
Search Forum

Buy Support
Incidents

If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:

Click Here
If you can't login and post questions or you are having trouble viewing forum posts:
Click Here
Callback
Support

If you live in USA, UK, Canada, Australia or New Zealand, you can leave us details on your question and request us to call you back and discuss them with you personally  (charges apply).

Click Here
 
Buy Support
Incidents
If you can't find your answer in the FREE PUBLIC QDeveloper Forum, require URGENT Priority Support, or you need to send us private or confidential information:
Click Here

Forum : Delete Operation Very SlowSearch Forum

Forum Home > FlexODBC - ODBC Driver for DataFlex Embedded DBMS > FlexODBC Forum

 New Topic 
 
 Post Reply 
[1]  
 Delete Operation Very Slow 
 Author   Message 
  Rob 
  
 Group: Members 
 Posts: 2 
 Joined: 2007-08-26 
 Profile
 Posted : 2007-08-26 05:54:25
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? 

  Top 
  Tom 
  6c3c1_sdk-qodbc.gif
 Group: Administrator 
 Posts: 5510 
 Joined: 2006-02-17 
 Profile
 Posted : 2007-08-27 08:19:14

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, dependant 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 Personnal!

 

  Top 
  Rob 
  
 Group: Members 
 Posts: 2 
 Joined: 2007-08-26 
 Profile
 Posted : 2007-08-27 09:03:45
Thanks for the pointer, the sales guy of course didn't mention any of this when I explained to him exactly what I was trying to do.  Maybe a pointer in the documentation indicating that the delete operation is mind-numbingly inefficient would be helpful to people like me who know nothing about DataFlex except what a PITA it is to work with.  We have an installation of DataFlex for the legacy program I am trying to fix and I was able to hunt down the "DFFILE" utlity, I'll give this a try as soon as I find a DOS-compatible machine (our copy will apparently only run on pre-Win2k machines).  Thanks again for the help. 

  Top 
 New Topic 
 
 Post Reply 
[1]  

Jump to