How many PDOX users still work well?

How many PDOX users still work well?

Post by PaulMB » Sat, 25 Oct 1997 04:00:00



I work at a repair center that has a has approx 100 simultaneous users on a
 netware server.  I am pushing to have all of our current data running unix
 software moved to Paradox 8 for windows.  I have already wrotes some PDOX 7
 apps for about 10 users which works well.  We move in approx a thousand items
 for repair a day to our warehouse.  Additionally to this we do 400 or 500
 repair shop transactions, parts center transactions, customer support
 transactions, etc. per day.   We have 150 employees.  Can Paradox 8 for
 Windows handle this many concurant users without bogging down.  Our main data
 base would probably be running 10 to 20k records on average with multiple
 tables to be tied relationally in the forms and reports.  Another question is
 if our business grows to 300 employees like we're expecting in a year or 2 can
 PDOX 8 handle even more users successfully?  These are question aimed at me by
 our IS manager who wants to use SQL server or Oracle. His argument is that
 PDOX is a personal data base software that can't handle a large user load.
 I'm wondering if any of you have had experience at this and can give me some
 advice.

thanks,

Paul Bilka

 
 
 

How many PDOX users still work well?

Post by Hiran Chaudhur » Sat, 25 Oct 1997 04:00:00




> >I work at a repair center that has a has approx 100 simultaneous users on a
> > netware server.  I am pushing to have all of our current data running unix
> > software moved to Paradox 8 for windows.  I have already wrotes some PDOX 7
> > apps for about 10 users which works well.  We move in approx a thousand items
> > for repair a day to our warehouse.  Additionally to this we do 400 or 500
> > repair shop transactions, parts center transactions, customer support
> > transactions, etc. per day.   We have 150 employees.  Can Paradox 8 for
> > Windows handle this many concurant users without bogging down.  Our main data
> > base would probably be running 10 to 20k records on average with multiple
> > tables to be tied relationally in the forms and reports.  Another question is
> > if our business grows to 300 employees like we're expecting in a year or 2 can
> > PDOX 8 handle even more users successfully?  These are question aimed at me by
> > our IS manager who wants to use SQL server or Oracle. His argument is that
> > PDOX is a personal data base software that can't handle a large user load.
> > I'm wondering if any of you have had experience at this and can give me some
> > advice.

> As the number of simultaneous writers to a file-server database goes up, the
> risk of one of those computers "doing it wrong" also increases.  The number of
> users (if they are mostly reading and if the data is efficiently indexed)
> matters less.

> However...  I, too, am beginning to steer my business more and more toward
> servers, because you only have to worry about one of the computers going down,
> plus you have transaction support.  The product we're using is Borland's
> InterBase, which BTW runs on many Unix servers, as well as NT and Netware.

> In your situation, I respectfully agree with your IS manager.  I think that
> keeping the data on the Unix box, under the auspices of a server (and quite
> possibly,* simple terminals(!) off the Unix box and/or a network of
> multi-user Unix boxes) would make the most sense and be the most efficient use
> of resources.

> I mean, think about this too ...  you're gonna buy 300 computers for these 300
> people at more than $1,000 a pop?  Dumb terminals can be had for $100 or less.

And think of the administration cost.

Hiran

 
 
 

How many PDOX users still work well?

Post by Sundial Servic » Sat, 25 Oct 1997 04:00:00



>I work at a repair center that has a has approx 100 simultaneous users on a
> netware server.  I am pushing to have all of our current data running unix
> software moved to Paradox 8 for windows.  I have already wrotes some PDOX 7
> apps for about 10 users which works well.  We move in approx a thousand items
> for repair a day to our warehouse.  Additionally to this we do 400 or 500
> repair shop transactions, parts center transactions, customer support
> transactions, etc. per day.   We have 150 employees.  Can Paradox 8 for
> Windows handle this many concurant users without bogging down.  Our main data
> base would probably be running 10 to 20k records on average with multiple
> tables to be tied relationally in the forms and reports.  Another question is
> if our business grows to 300 employees like we're expecting in a year or 2 can
> PDOX 8 handle even more users successfully?  These are question aimed at me by
> our IS manager who wants to use SQL server or Oracle. His argument is that
> PDOX is a personal data base software that can't handle a large user load.
> I'm wondering if any of you have had experience at this and can give me some
> advice.

As the number of simultaneous writers to a file-server database goes up, the
risk of one of those computers "doing it wrong" also increases.  The number of
users (if they are mostly reading and if the data is efficiently indexed)
matters less.

However...  I, too, am beginning to steer my business more and more toward
servers, because you only have to worry about one of the computers going down,
plus you have transaction support.  The product we're using is Borland's
InterBase, which BTW runs on many Unix servers, as well as NT and Netware.

In your situation, I respectfully agree with your IS manager.  I think that
keeping the data on the Unix box, under the auspices of a server (and quite
possibly,* simple terminals(!) off the Unix box and/or a network of
multi-user Unix boxes) would make the most sense and be the most efficient use
of resources.

I mean, think about this too ...  you're gonna buy 300 computers for these 300
people at more than $1,000 a pop?  Dumb terminals can be had for $100 or less.

 
 
 

1. PrintLandScape works in PDox 7 but not in PDox 8

Anybody have any idea why this doesn't print my report in landscape?
This works in PDox 7 but not in PDox8.

method pushButton(var eventInfo Event)
var

  myreport report
  ChrtFail Logical
  FailMsg String

  repInfo reportPrintInfo
endVar

inschartdata(ChrtFail,FailMsg)
if chrtFail then
 msgInfo("Failure",FailMsg)
 return
endif

if myreport.open(":work:INSANS") then
myreport.dates = "Report Generated for: "+ DateFrom+" through "+Dateto
if BUTTON2 = True then
 repinfo.orient = PrintLandScape
 myreport.print(RepInfo)
endif

myreport.maximize()
myreport.menuAction(menuPropertieszoomFitWidth)
endif
endMethod

2. Cannot see databases

3. QT Stills

4. February Meeting of Computer Museum Society in Sydney, Australia.

5. pdox 3.5 forms app was single user, now want to run concurrent users

6. My @@identity returns a different value than that in the table?

7. Pdox 3.5 vs.Pdox 4.02 vs. Pdox 4.5

8. Problem with BCP

9. Q: Which format is best ? dBase or Pdox

10. Prove that Delphi is better than PDox :-)

11. Really now, is Pdox better than Access?

12. 5 user licenses of SQL SERVER 7 will hamper 200 users working on intranet applic

13. My menus don't work in Pdox 9