Someone work to dbf yet?

Are you asking if we still use DBF tables? If so, then yes...many developers 
still use them.

"Salvatore Megna"  wrote in message 
news:254fff16$5a2ff089$47a9a@news.alaska-software.com...

Someone work to dbf yet?

I work with a shared folder on server
A customer have a problem with my software because when there are more 
workstation connect my software slowe.
I have other customers with more workstations but they haven't this problem.
I often think that I must change database




Il 24/09/2019 20:11, Scott Krise ha scritto:
> Are you asking if we still use DBF tables? If so, then yes...many 
> developers still use them.
> 
> "Salvatore Megna"  wrote in message 
> news:254fff16$5a2ff089$47a9a@news.alaska-software.com...
> 
> Someone work to dbf yet?

hi,

> I work with a shared folder on server
> A customer have a problem with my software because when there are more
> workstation connect my software slowe.
> I have other customers with more workstations but they haven't this
> problem.
> I often think that I must change database

did you know about SMB ?

did you use Drive-Letter or UNC Path ( \\Server\FolderName ) ?



---
Diese E-Mail wurde von AVG auf Viren geprüft.
http://www.avg.com

Drive-letter.
No I dont know SMB now I look in internet


Il 26/09/2019 20:28, Jim Lee ha scritto:
> hi,
> 
>> I work with a shared folder on server
>> A customer have a problem with my software because when there are more
>> workstation connect my software slowe.
>> I have other customers with more workstations but they haven't this
>> problem.
>> I often think that I must change database
> 
> did you know about SMB ?
> 
> did you use Drive-Letter or UNC Path ( \\Server\FolderName ) ?
> 
> 
> 
> ---
> Diese E-Mail wurde von AVG auf Viren geprüft.
> http://www.avg.com
>

Hi Mr. Salvatore

On subject of still using dbf is "still some, but starting to avoid them of possbile"

For everything new, I ditched dbf years ago and stick to SQL over ODBC. Too much hassle when considering security issues & GDPR compliance, logging, audit trail and securing anything on Windows servers.

They are still used in some older systems/apps and for storing temporary data for reporting tools, but i try to ditch that aspect of using dbf as well and going for memory-only tables (arrays irl) .

Greetings


Salvatore Megna <smegna@tiscali.it> wrote in message news:b5435ca4-9929-59ad-0980-c63067a303b8@tiscali.it...
>I work with a shared folder on server
>A customer have a problem with my software because when there are more 
>workstation connect my software slowe.
>I have other customers with more workstations but they haven't this problem.
>I often think that I must change database
>
>
>
>
>Il 24/09/2019 20:11, Scott Krise ha scritto:
>> Are you asking if we still use DBF tables? If so, then yes...many 
>> developers still use them.
>> 
>> "Salvatore Megna"  wrote in message 
>> news:254fff16$5a2ff089$47a9a@news.alaska-software.com...
>> 
>> Someone work to dbf yet?

On 9/26/19 9:29 AM, Salvatore Megna wrote:
> 
> I work with a shared folder on server
> A customer have a problem with my software because when there are more 
> workstation connect my software slowe.
> I have other customers with more workstations but they haven't this 
> problem.
> I often think that I must change database
> 
> 
> 
> 
> Il 24/09/2019 20:11, Scott Krise ha scritto:
>> Are you asking if we still use DBF tables? If so, then yes...many 
>> developers still use them.
>>
>> "Salvatore Megna"  wrote in message 
>> news:254fff16$5a2ff089$47a9a@news.alaska-software.com...
>>
>> Someone work to dbf yet?
> 


Lots of things can effect speed.

Speed of network, speed of server, speed of work station.

If one bad/slow NIC card the whole network is reduced to that ones bad 
speed. Iffy cabling can cause problems as well as switches and hubs. Had 
a site go slow turned out a mouse had chewed the cable. A good network 
analysis should be done.

Also work load. When an append or read happens the index file is locked 
until it is completed. This slows other users. SO if one site has more 
activity it will be slower then one that has less regardless of number 
of users all other things being equal.

I think CDX is better then NTX because less file handles. But reindex 
command can cause CDX files to grow larger. Best to delete and rebuild 
from scratch.

Jim

Il 27/09/2019 16:53, James Loughner ha scritto:
> On 9/26/19 9:29 AM, Salvatore Megna wrote:
>>
>> I work with a shared folder on server
>> A customer have a problem with my software because when there are more 
>> workstation connect my software slowe.
>> I have other customers with more workstations but they haven't this 
>> problem.
>> I often think that I must change database
>>
>>
>>
>>
>> Il 24/09/2019 20:11, Scott Krise ha scritto:
>>> Are you asking if we still use DBF tables? If so, then yes...many 
>>> developers still use them.
>>>
>>> "Salvatore Megna"  wrote in message 
>>> news:254fff16$5a2ff089$47a9a@news.alaska-software.com...
>>>
>>> Someone work to dbf yet?
>>
> 
> 
> Lots of things can effect speed.
> 
> Speed of network, speed of server, speed of work station.
> 
> If one bad/slow NIC card the whole network is reduced to that ones bad 
> speed. Iffy cabling can cause problems as well as switches and hubs. Had 
> a site go slow turned out a mouse had chewed the cable. A good network 
> analysis should be done.
> 
> Also work load. When an append or read happens the index file is locked 
> until it is completed. This slows other users. SO if one site has more 
> activity it will be slower then one that has less regardless of number 
> of users all other things being equal.
> 
> I think CDX is better then NTX because less file handles. But reindex 
> command can cause CDX files to grow larger. Best to delete and rebuild 
> from scratch.
> 
> Jim
> 
> 
> 
> 
> 
> 
> 
Niente da fare. Ho abilitato smb1 su tutti i client che lo avevano 
disabilitato ma niente è cambiato.
Quando lavorano più postazioni sul programma ogni passaggio è rallentato.
Sia i dbf che il programma sono  sul server in cartella separate.
Non so più cosa controllare.

Il 02/10/2019 10.11, Salvatore Megna ha scritto:
> Il 27/09/2019 16:53, James Loughner ha scritto:
>> On 9/26/19 9:29 AM, Salvatore Megna wrote:
>>>
>>> I work with a shared folder on server
>>> A customer have a problem with my software because when there are 
>>> more workstation connect my software slowe.
>>> I have other customers with more workstations but they haven't this 
>>> problem.
>>> I often think that I must change database
>>>
>>>
>>>
>>>
>>> Il 24/09/2019 20:11, Scott Krise ha scritto:
>>>> Are you asking if we still use DBF tables? If so, then yes...many 
>>>> developers still use them.
>>>>
>>>> "Salvatore Megna"  wrote in message 
>>>> news:254fff16$5a2ff089$47a9a@news.alaska-software.com...
>>>>
>>>> Someone work to dbf yet?
>>>
>>
>>
>> Lots of things can effect speed.
>>
>> Speed of network, speed of server, speed of work station.
>>
>> If one bad/slow NIC card the whole network is reduced to that ones bad 
>> speed. Iffy cabling can cause problems as well as switches and hubs. 
>> Had a site go slow turned out a mouse had chewed the cable. A good 
>> network analysis should be done.
>>
>> Also work load. When an append or read happens the index file is 
>> locked until it is completed. This slows other users. SO if one site 
>> has more activity it will be slower then one that has less regardless 
>> of number of users all other things being equal.
>>
>> I think CDX is better then NTX because less file handles. But reindex 
>> command can cause CDX files to grow larger. Best to delete and rebuild 
>> from scratch.
>>
>> Jim
>>
>>
>>
>>
>>
>>
>>
> Niente da fare. Ho abilitato smb1 su tutti i client che lo avevano 
> disabilitato ma niente è cambiato.
> Quando lavorano più postazioni sul programma ogni passaggio è rallentato.
> Sia i dbf che il programma sono  sul server in cartella separate.
> Non so più cosa controllare.
> 
prova "smb2-infocache.msi" da alaska
oppure come ho fatto io , server dedicato ( win 7 o win 10 )ed accesso 
dai client con RDP.
ciao

hi,

> prova "smb2-infocache.msi" da alaska
> oppure come ho fatto io , server dedicato ( win 7 o win 10 )ed accesso dai
> client con RDP.

that SMB2 Patch is for LanmanagerWorkstation and have no Effect on Server
as you say you use Drive-Letter which use LanManager and SMB1 over UPD Port
135-139
to use Drive-Letter is since Windows Vista obsolete !

do you remember WannaCry ? it use UDP Port to get into your OS
Windows 10 DEFAULT disable SMB1 while it is NOT Secure
so use UNC-Path

---

all File based Database need SMB in Network to share Data so it will always
slow down with 2nd User.
you have to use a Client / Server like PostgreSQL or MySQL to get rid of SMB
and its Problem.



---
Diese E-Mail wurde von AVG auf Viren geprüft.
http://www.avg.com

Il 02/10/19 15:45, Solving ha scritto:

...

>>>> I work with a shared folder on server
>>>> A customer have a problem with my software because when there are 
>>>> more workstation connect my software slowe.
>>>> I have other customers with more workstations but they haven't this 
>>>> problem.
>>>> I often think that I must change database

Too much trouble for me.

> prova "smb2-infocache.msi" da alaska
> oppure come ho fatto io , server dedicato ( win 7 o win 10 )ed accesso 
> dai client con RDP.

I've got the same solution. On multi user situation I use RDP, but
to avoid Server class OS, I use this:

https://www.thinstuff.com/products/xpvs-server/

which is cheap and reliable

Claudio

Salvatore Megna <smegna@tiscali.it> wrote in message news:254fff16$5a2ff089$47a9a@news.alaska-software.com...
>Someone work to dbf yet?

I am. Since the beginning of my career till now.
From DBF/IDX to DBF/CDX and DBF/NTX now.

Full fledged application with Cash/Bank, Inventory, GST (Taxes) etc. Entries and Reports.

Regards,

Anand

On 9/25/2019 5:48 AM, Anand Gupta wrote:
> Salvatore Megna <smegna@tiscali.it> wrote in message news:254fff16$5a2ff089$47a9a@news.alaska-software.com...
>> Someone work to dbf yet?
> 
> I am. Since the beginning of my career till now.
>  From DBF/IDX to DBF/CDX and DBF/NTX now.
> 
> Full fledged application with Cash/Bank, Inventory, GST (Taxes) etc. Entries and Reports.
> 
> Regards,
> 
> Anand
> 
Hi Anand,

I too use DBF/CDX (with Advantage Database Server) but am curious about 
your reply.  Are you using DBF/CDX concurrently or did you migrate from 
DBF/CDX to DBF/NTX and if so I'm curious as to why?

Thanks... Jonathan

jonathan.leeming@familycentre.org
Edmonton, Alberta, Canada

Jonathan Leeming wrote in message news:1735b9e6$5eaff297$4a877@news.alaska-software.com...
>On 9/25/2019 5:48 AM, Anand Gupta wrote:
>> Salvatore Megna <smegna@tiscali.it> wrote in message news:254fff16$5a2ff089$47a9a@news.alaska-software.com...
>>> Someone work to dbf yet?
>> 
>> I am. Since the beginning of my career till now.
>>  From DBF/IDX to DBF/CDX and DBF/NTX now.
>> 
>> Full fledged application with Cash/Bank, Inventory, GST (Taxes) etc. Entries and Reports.
>> 
>> Regards,
>> 
>> Anand
>> 
>Hi Anand,
>
>I too use DBF/CDX (with Advantage Database Server) but am curious about 
>your reply.  Are you using DBF/CDX concurrently or did you migrate from 
>DBF/CDX to DBF/NTX and if so I'm curious as to why?
>
>Thanks... Jonathan

Hi Jonathan,

Well I am using what is required/demand of user. You can say I migrated from one to another.

When I started, the company used dBASEII (dbf/ntx). Then as I progressed in my career and in different companies, I had to use FoxBase > FoxPro (dbf/idx) and (dbf/cdx). Now at current company I use Xbase++ (dbf/ntx), because the companies initial app was in Clipper 87 and used dbf/ntx. From there we upgraded to Clipper 5 and then to Xbase++, but the database remained same for compatibility of our huge customer base.

We also have option to switch to ADS (dbf/ntx) in the same app.

So you see it is by design and not by choice that I am still using dbf/ntx. But I am happy as I am earning my livelihood from it, which matters most.

Regards,

Anand

On 9/26/2019 4:15 AM, Anand Gupta wrote:
> Jonathan Leeming wrote in message news:1735b9e6$5eaff297$4a877@news.alaska-software.com...
>> On 9/25/2019 5:48 AM, Anand Gupta wrote:
>>> Salvatore Megna <smegna@tiscali.it> wrote in message news:254fff16$5a2ff089$47a9a@news.alaska-software.com...
>>>> Someone work to dbf yet?
>>>
>>> I am. Since the beginning of my career till now.
>>>   From DBF/IDX to DBF/CDX and DBF/NTX now.
>>>
>>> Full fledged application with Cash/Bank, Inventory, GST (Taxes) etc. Entries and Reports.
>>>
>>> Regards,
>>>
>>> Anand
>>>
>> Hi Anand,
>>
>> I too use DBF/CDX (with Advantage Database Server) but am curious about
>> your reply.  Are you using DBF/CDX concurrently or did you migrate from
>> DBF/CDX to DBF/NTX and if so I'm curious as to why?
>>
>> Thanks... Jonathan
> 
> Hi Jonathan,
> 
> Well I am using what is required/demand of user. You can say I migrated from one to another.
> 
> When I started, the company used dBASEII (dbf/ntx). Then as I progressed in my career and in different companies, I had to use FoxBase > FoxPro (dbf/idx) and (dbf/cdx). Now at current company I use Xbase++ (dbf/ntx), because the companies initial app was in Clipper 87 and used dbf/ntx. From there we upgraded to Clipper 5 and then to Xbase++, but the database remained same for compatibility of our huge customer base.
> 
> We also have option to switch to ADS (dbf/ntx) in the same app.
> 
> So you see it is by design and not by choice that I am still using dbf/ntx. But I am happy as I am earning my livelihood from it, which matters most.
> 
> Regards,
> 
> Anand
> 
Hi Anand,

Makes sense!  With my main application I migrated from Clipper to 
Xbase++ 1.9 (major re-write going to GUI but Topdown was a big help!) 
and now with 2.0.  I migrated my DBF/DBT/NTX with ADS over to 
DBF/FPT/CDX still with ADS in fall of 2016 so when I saw your posting I 
thought perhaps I was missing something!

Glad to hear you are enjoying your craft!

Regards... Jonathan

jonathan.leeming@familycentre.org
Edmonton, Alberta, Canada

26.09.2019 16:57 tarihinde Jonathan Leeming yazdı:
> On 9/26/2019 4:15 AM, Anand Gupta wrote:
>> Jonathan Leeming wrote in message 
>> news:1735b9e6$5eaff297$4a877@news.alaska-software.com...
>>> On 9/25/2019 5:48 AM, Anand Gupta wrote:
>>>> Salvatore Megna <smegna@tiscali.it> wrote in message 
>>>> news:254fff16$5a2ff089$47a9a@news.alaska-software.com...
>>>>> Someone work to dbf yet?
>>>>
>>>> I am. Since the beginning of my career till now.
>>>>   From DBF/IDX to DBF/CDX and DBF/NTX now.
>>>>
>>>> Full fledged application with Cash/Bank, Inventory, GST (Taxes) etc. 
>>>> Entries and Reports.
>>>>
>>>> Regards,
>>>>
>>>> Anand
>>>>
>>> Hi Anand,
>>>
>>> I too use DBF/CDX (with Advantage Database Server) but am curious about
>>> your reply.  Are you using DBF/CDX concurrently or did you migrate from
>>> DBF/CDX to DBF/NTX and if so I'm curious as to why?
>>>
>>> Thanks... Jonathan
>>
>> Hi Jonathan,
>>
>> Well I am using what is required/demand of user. You can say I 
>> migrated from one to another.
>>
>> When I started, the company used dBASEII (dbf/ntx). Then as I 
>> progressed in my career and in different companies, I had to use 
>> FoxBase > FoxPro (dbf/idx) and (dbf/cdx). Now at current company I use 
>> Xbase++ (dbf/ntx), because the companies initial app was in Clipper 87 
>> and used dbf/ntx. From there we upgraded to Clipper 5 and then to 
>> Xbase++, but the database remained same for compatibility of our huge 
>> customer base.
>>
>> We also have option to switch to ADS (dbf/ntx) in the same app.
>>
>> So you see it is by design and not by choice that I am still using 
>> dbf/ntx. But I am happy as I am earning my livelihood from it, which 
>> matters most.
>>
>> Regards,
>>
>> Anand
>>
> Hi Anand,
> 
> Makes sense!  With my main application I migrated from Clipper to 
> Xbase++ 1.9 (major re-write going to GUI but Topdown was a big help!) 
> and now with 2.0.  I migrated my DBF/DBT/NTX with ADS over to 
> DBF/FPT/CDX still with ADS in fall of 2016 so when I saw your posting I 
> thought perhaps I was missing something!
> 
> Glad to hear you are enjoying your craft!
> 
> Regards... Jonathan
> 
Hi,
I have been using ADS with DBF/CDX since 1994, firstly with Clipper 5.3x 
and now with xbase++ v.1.9.355 without any problem. In stand alone or in 
network. I have not seen any problem with speed. As I experienced; 
slowing majorly caused by hardware configuration as Jonathan says.
rgds
Nevzat

Hi,
Don't you have slowdown problems with windows 10 updates?
Do you do dbf searches with seek and do while?
Do you have any examples?
Thank you so much

Il 25/09/2019 13:48, Anand Gupta ha scritto:
> Salvatore Megna <smegna@tiscali.it> wrote in message news:254fff16$5a2ff089$47a9a@news.alaska-software.com...
>> Someone work to dbf yet?
> 
> I am. Since the beginning of my career till now.
>  From DBF/IDX to DBF/CDX and DBF/NTX now.
> 
> Full fledged application with Cash/Bank, Inventory, GST (Taxes) etc. Entries and Reports.
> 
> Regards,
> 
> Anand
>

Salvatore Megna <smegna@tiscali.it> wrote in message news:4adcf46d$3b0cfe45$3f04d@news.alaska-software.com...
>Hi,
>Don't you have slowdown problems with windows 10 updates?
>Do you do dbf searches with seek and do while?
>Do you have any examples?
>Thank you so much
>
>Il 25/09/2019 13:48, Anand Gupta ha scritto:
>> Salvatore Megna <smegna@tiscali.it> wrote in message news:254fff16$5a2ff089$47a9a@news.alaska-software.com...
>>> Someone work to dbf yet?
>> 
>> I am. Since the beginning of my career till now.
>>  From DBF/IDX to DBF/CDX and DBF/NTX now.
>> 
>> Full fledged application with Cash/Bank, Inventory, GST (Taxes) etc. Entries and Reports.
>> 
>> Regards,
>> 
>> Anand
>>

Hi Salvatore,

I hope you are asking me.
1. No slow down in w10
2. Yes seek and while
3. All my apps have these codes. What type of example you need ?
In fact I use TopDown to its fullest and many codes are from it.

Regards,

Anand