FrançaisEnglishEspañol
PC SOFTForums homeLast messagesOnline repository
PC SOFT
Find...
Perform the searchSearch in...
Newsgroup dedicated to WINDEV (current version), in English
Hyperfilesql server speed and dependability
Dec., 22nd 2009 at 03:34 PM
joe crevino
<gu...st@news.pcsoft.fr>


We are currently doing a rewrite of a app written in windev 10 running on mysql server. The rewrite will be in windev 14. We are considering using hyperfile sql.
There are 20 to 100 users on the system at all times. Any ideas of hyerfile sql will work ?
Using it would be a savings of serveral thousand dollars for the client.
thank you and have a happy holiday,
joe


Replies to this message:
Re: hyperfilesql server speed and dependability
Hi again I DID answer you.. What I said is NOT theoretical but extremely practical and for HFSQL... And it explains why QUERIES are faster than what you call direct access (ie table linked to files or ...
From Fabrice Harari - Dec., 27th 2009 - More »
Re: hyperfilesql server speed and dependability
Yes. I know and agree with all your constants but, I ask simple question for experienced users about using query's (not MS but HyperFile) with forms, browses and so on in real world with WD. Your answ ...
From ICI - Dec., 27th 2009 - More »
Re: hyperfilesql server speed and dependability
That explains it ... I have been working on some extremely fast networks with lots of memory. thank you, joe
From joe crevino - Dec., 25th 2009 - More »
Re: hyperfilesql server speed and dependability
Hi Joe... Most of the work I have done is with the various Native access dll's from windev. As far as the hyperfile sql I have not found much difference in performance between sql statements and the ...
From Fabrice Harari - Dec., 25th 2009 - More »
Re: hyperfilesql server speed and dependability
Most of the work I have done is with the various Native access dll's from windev. As far as the hyperfile sql I have not found much difference in performance between sql statements and the windev lang ...
From joe crevino - Dec., 24th 2009 - More »
Re: hyperfilesql server speed and dependability
I know for indexing and it is not a question. I am experienced programmer years 20+ with database software and I know how to make good index. I am pretty new with WD. I am also write about query's whi ...
From ICI - Dec., 24th 2009 - More »
Re: hyperfilesql server speed and dependability
I find the how you index your data is extemely import. I have a stopwatch very handy. I always use huge amounts of test data to test for speed. Using data that does not have proper indexing will caus ...
From joe crevino - Dec., 23rd 2009 - More »
Re: hyperfilesql server speed and dependability
Hi Joe, I think you would be happy with HFCS too. We have a number of HFCS databases with >2 million records, and one in particular, that has over 7 million records with 100's of concurrent users ...
From tfischbeck - Dec., 23rd 2009 - More »
Re: hyperfilesql server speed and dependability
Question on question. WD12. If we here with discussion about HF/HFCS, I have one question closely connected with this. 'Course question is for experienced already here. I read answers with many table ...
From ICI - Dec., 23rd 2009 - More »
Re: hyperfilesql server speed and dependability
Hi Joe, We use HFCS in the meal service lines at the larger schools. There are only 4-6 users but heavy transaction volumes during meals with a lot of data, including photos, moving around. We have ha ...
From Jeff Graham - Dec., 23rd 2009 - More »
Re: hyperfilesql server speed and dependability
Hi Joe, We are using HFsql classic for over 10 years on a Novell network with 50+ users and have not had a single database problem al these years. We are currently using WD 12. We have more than 100 ...
From Piet van Zanten - Dec., 22nd 2009 - More »
Re: hyperfilesql server speed and dependability
Joe, We use MSSQL and Hyperfile SQL with equal success with more than 100 users on a WAN and the apps are currently written using WD14. Milton
From Milton - Dec., 22nd 2009 - More »
Re: hyperfilesql server speed and dependability
Hi Joe, I've not used Hyperfile so I'm only offering an unsubstantiated opinion. PCSoft is not in the business of creating database engines and so I'm supposing they do not have the skill or the resou ...
From Glenn Rathke - Dec., 22nd 2009 - More »
Re: Hyperfilesql server speed and dependability
Hi Joe... this kind of volume is certainly not a problem for HFCS, as long as queries are optimized correctly by adding the appropirate keys in the DB Best regards -- Fabrice Harari International WinD ...
From Fabrice Harari - Dec., 22nd 2009 - More »