Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v6.0
  HXTT Cobol v3.0
  HXTT DBF v6.0
  Buy Now
  HXTT Excel v5.0
  HXTT Paradox v6.0
  HXTT Text(CSV) v6.0
  HXTT XML v2.0
Offshore Outsourcing
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
Heng Xing Tian Tai Lab of Beijing City (abbr, HXTT)

DBF Deletes w/ColdFusion
Paul Hall
2007-07-10 20:55:19.0
As you suggested, I put the phrase "DeletesAreVisible=true" in the
connection string box for my VFP Data Source. However, I must
have something wrong. My records tagged for delete (but not packed)
are still not showing up in my query.

I will send a screen shot by email.

Also, I've apparently forgotten my password. I twice requested the
password be sent to me on you "forgot your password" section.
(Last night and then again tonight) The message said my password
would be sent to me shortly. But, I still have not received the password??

Thanks, Paul Hall
Re:DBF Deletes w/ColdFusion
HXTT Support
2007-07-10 21:05:04.0
>My records tagged for delete (but not packed) are still not showing up in my query.
You can try "select * from yourTable where deleted()" to see whether you can get those deleted rows. If it returns rows, it's corrrect.

If your query is "SELECT COUNT(*) from myTable where ST = "AR"", and your ST is indexed with filtered condition !deleted(), then HXTT DBF won't return thosed deleted rows since it's using that index file to query.
Re:Re:DBF Deletes w/ColdFusion
HXTT Support
2007-07-10 21:28:45.0
According to the Note at .
Note: Connection String seems abnormal now. You should have to put Connection String into JDBC URL, for instance: jdbc:dbf:/c:data?delayedClose=15;maxCacheSize=6144;lockTimeout=2000;

It seems that your ColdFusion has that issue too. Please try to use jdbc:dbf:/c:/AAAMo/Dictionary?DeletesAreVisible=true
Re:Re:Re:DBF Deletes w/ColdFusion
Paul Hall
2007-07-11 04:31:44.0
Yes!!! jdbc:dbf:/c:/AAAMo/Dictionary?DeletesAreVisible=true

I updated to your latest version and put this parameter into my
JDBC URL string and my count(*) queries now work very well !!
Thank you SO much.

I now must improve the performance of my table join queries.
Do you have any suggestions?

Again, Thank You !
Re:Re:Re:Re:DBF Deletes w/ColdFusion
HXTT Support
2007-07-11 05:02:35.0
>I now must improve the performance of my table join queries.
>Do you have any suggestions?
What's your sql sample?
Re:Re:Re:Re:Re:DBF Deletes w/ColdFusion
Paul Hall
2007-07-17 04:16:03.0
It is a long SQL statement with a double join submitted
from a ColdFusion cfquery. But, it runs in under one
second in VFP.:

Thanks for any help you can provide.


SELECT cc.cid as cid,
dd.leadstatus as leadstatus,
dd.lstatcod as lstatcode,
alltrim(strtran(strtran(' ' + substr(ttoc(cc.nextfudat),1,16),' 0',' '),'200','0')) + lower(substr(ttoc(cc.nextfudat),21,1))+' ' as fudatm,
dd.recsourcep as recsource,
dd.coverage1 as quotenum,
dd.xdate ,
cc.agentidp as agent1 ,
pp.branchlocp ,
pp.citypc ,
pp.phonepc1 ,
iif(inlist(pp.phonind,'X'),'Do Not Call',iif(pp.sdnp='1',iif('1','st/fed ','st list '),iif('1','fed list ',' '))) as dnc,
dd.commentsd as leadnotes1 ,
cc.hhnew as hhnew,
substr(alltrim(cc.membprod)+' ',1,12) as memprod,
pp.memnonp as memnon,
dtos(nextfudat)+' '+substr(TTOC(nextfudat,1),9,4) as nextfu,

FROM (contacts cc left join Prospdet dd on cc.membprod=dd.membprod)
left join prospects pp on cc.hhnew=pp.hhnew

WHERE cc.hhnew>1 and
(not (inlist(dd.leadstatus,'Drop') or inlist(cc.tskstatus,'Canc'))) and
(not cc.tskstatus=iif('#pShowDone#'='false' ,'Done','QQ')) and
mid(cc.agentidp,1,len(trim(iif('#pSysLevel#'='7','#pCombAgent#','#pSysUserName#')))) =
iif('#pSysLevel#'='7','#pCombAgent#','#pSysUserName#') and
mid(dd.agentidp,1,len(trim(iif('#pSysLevel#'='7','#pCombAgent#','#pSysUserName#')))) =
iif('#pSysLevel#'='7','#pCombAgent#','#pSysUserName#') and
between(ttod(cc.nextfudat),iif(mid('#pFuT#',1,3)='All',ctod(' / / '),
iif(mid('#pFuT#',1,3)='Tod', ctod('#pCalDate#'),
iif(mid('#pFuT#',1,3)='Nex', ctod('#pCalDate#'),date() )))),

ORDER BY nextfudat
Re:Re:Re:Re:Re:Re:DBF Deletes w/ColdFusion
Paul Hall
2007-07-18 19:16:03.0
I was able to speed up the query by converting the joins to
implicit inner joins (FROM contacts cc, prospdet dd, prospects pp WHERE
cc.membprod=dd.membprod and cc.hhnew=pp.hhnew and ...)

Thanks! I'm happy the query speed is working. May have some
outer join issues later...but, for now is not a problem.
Re:Re:Re:Re:Re:Re:Re:DBF Deletes w/ColdFusion
HXTT Support
2007-07-19 04:57:36.0
Yeah. inner join is quicker than left/right/full join.
Re:Re:Re:Re:Re:Re:Re:Re:DBF Deletes w/ColdFusion
Paul Hall
2007-07-19 05:37:16.0
Left/Right/Full Joins are very quick in native VFP rushmore.
Do you have any plans to add these to your own speed
optimizing engine?

Thanks again for all your help.
Re:Re:Re:Re:Re:Re:Re:Re:DBF Deletes w/ColdFusion
HXTT Support
2007-07-19 06:52:34.0
Rushmore need many memory to construct temporary Join table. Now we haven't plan to quicken Left/Right/Full join, except for utlizing index.
Re:Re:Re:Re:Re:Re:Re:Re:DBF Deletes w/ColdFusion
Paul Hall
2007-07-19 08:47:27.0
Yeah you're right about the memory for Rushmore. Though, it's memory on the server, not the clients. So, I would gladly get extra memory for extra performance. However, I'm sure it would be too much extra effort to have a
"use Rushmore" option.

A java driver for VFP/Rushmore might do well against MySQL. Might be fun to show a side by side test on ColdFusion/Java/Flex forums. VFP/Rushmore does faster queries than even SQLSvr/ Oracle/ Informix for databases up to a million records, with the tuning we have.

So, I really appreciate your driver. Thanks. And, thanks for your support and answering my questions!
Re:Re:Re:Re:Re:Re:Re:Re:DBF Deletes w/ColdFusion
Paul Hall
2007-07-19 09:56:02.0
Sorry, I meant "for databases up to 10 million records" !
(which includes a lot of applications.)

Search Key   Search by Last 50 Questions


Copyright © 1999-2017 Heng Xing Tian Tai Lab of Beijing City. | All Rights Reserved. | Privacy | Legal | Sitemap