| |
| |
|
Rob
Wilts | I work in a quite umfangreichen proposition. DA be I but urgently on several User in the Netzwerkangewiesen. Profan can the (or. The work with Databases in the network functions too) but the program lose still some on speed.
has someone experience or Tipps? |
|
| |
| |
| |
|
|
 | the Program ists not what on speed lose - its sooner so the the networking (according to Netzwerkgeschwindigkeit) - The Übertragungsgeschwindigkeit the data certainly. there it networks gives which faster as Festplatten are - runs Program under Umständen even faster as of Festplatte. (particularly if The Endplatte the Ram is.)
circa what very goes it you because? |
|
| |
| |
| |
|
|
Rob
Wilts | you have right, naturally becomes the program not slower. or only indirect, there it itself circa a very complex Datenbankanwendung deals with z. T. Databases with several thousand Einträgen. there the program in the network inserted go should, are at least theoretical several User at the same time with the data joined, and can (or should) these naturally too change can.
the against means, that constantly read- Schreib- and Aktualisierungszugriffe erfolgen.
Konkret following ask, is it advisable in between The Databases zuschließen (with dbclose) and immediate again for Weiterarbeit to open, or. inverse, ought to one before each Schreibzugriff The data base new open (could itself what changed having)?
fundamentally: is the work with dbfs so configures, that always the whole Datenbestand loaded (means over network transportiert go must?) or position dbopen first of all only a link since and it'll according to demand the geforderte Datensatz transportiert.
If I know How the grundsätzliche HAndling is, can I effective strategien develop.
I hope the whole is something deutlicher become
Rob
P.s. could the employment of SQL-command one Lösungsweg his? |
|
| |
| |
| |
|
|
| means. 
there's naturally very plenty To mind - already on my own so it no Kollisionen gives. the schlimmst are Kollisionen - said I the already?
I lay now a functioning [Web]Server with PHP & DB-Support as basis solid.
The ClientAPP (CApp) sends the Server a demand - and wait the Result.
These Anforderungen must umbedingt gestapelt go - here lying the ploy. it is not only accordingly utterly unempfehlenswert The CApp directly with the DB To connecten - separate too from the Sicherheitsaspekt.
The CApps Send means simple Anforderungen on whom Server and this places these first ex. Each demand get one Ticket (a SID) - The the CApp too mitgeteilt becomes. One permanenter service on the Server (CronJob?) kümmert itself against around the dismantling the Stapels. The CApps Waiting as long as until one Result for the sustained Ticket receive.
the wars already.
i'm hierbei of it gone out the really a great many people within one large Projektes together a DB feed want. |
|
| |
| |
| |
|
|
 | | Gehts now circa a data base the network or circa a internet-data base, How MySQL |
|
| |
| |
| |
|
|
Rob
Wilts | hears itself well on, only that I in the relationship yet inexperienced be.
means the set lay I a functioning Webserver on übersteigt already my Experience. the follow up properly ... 
Vereinfacht said, operates each Version the suitable Users almost so, How in the Single pursued, except that eachone User only on Databases on one computer zugreift.
ALso: integrally so many User go it well not his, 1-4 max. at the same time. any lay at Start The link (way) to the Databases solid and reading (and write) in this data. As I said the functions in first Test too integrally well, d.h. writes User A data, so can user B with the next demand The (modified) data too reading and see. therefore let I in the rule The data base too first new open, before one set written becomes.
in the Grunde - if I you right understand promise You one other trouble on: The safety. where I safety in the senses of Integrität understand?
the ursprüngliche trouble, that I ansprach is the speed. here helps Perhaps too simple try. |
|
| |
| |
| |
|
|
Rob
Wilts | How Perhaps from whom previous BEiträgen obviously: It's all right solely circa Databases in the local networking.
the Topic Databases Internet would later of interest.
As I said Notes eachone manner are willkomen |
|
| |
| |
| |
|
|
Torsten
Rümker | Hi,
you should In any drop once more above cogitate, whether The strategy each Client direct Access to The data base To gestatten well is!
fundamentally ought to the namely not happen.
The (for Datenbestand) sicherste method is a Server to create, the The data according to inquire available position. (OK had iF already said)
On The manner saving one itself additional Datentransfer over the networking, the z.B. through Search in the data base come into being would, what then again the speed zugute comes.
so falls then too well the dbopen to the write the data wech ;)
MfG
Torsten |
|
| |
| Ich lerne, ob ich will oder nicht!
Betriebssystem:
- Ubuntu 15.x
- Windows (diverse)
XProfan Version: X2 | 10/02/05 ▲ |
|
| |
|
|
| in the Grunde takes sichs nothing whether DB Internet or DB in the Lan - because both DBs are no local.
1-4 user are really not plenty - but the Problematik remaining The same.
[quote:f38503daa9]where I safety in the senses of Integrität understand?[/quote:f38503daa9]not solely - but absolute Integrität particularly with Stress ought to priority having.
time a couple ask:
which is the ServerOS? (WinXPPro?)
which is the ClientOS ? (WinXPHome?)
what kind of DBFormat lying to? (SQL?)
Idea of ODBC? |
|
| |
| |
| |
|
|
Rob
Wilts | OS XP-Prof
DB lying in dBase 4-stature to
No idea of ODBC |
|
| |
| |
| |
|
|
| |
| |
| |
| |
|
|
Rob
Wilts | thanks but can't say, I really weitergekommen be
the following small BEispielprogramm
cls
declare A&
CHDIR DATA
print getdir$(@)
A&=@SQLINIT(DSN=FBS_ORG)
print a&
SQLEXEC SELECT * FROM KURSPROGRAMM.DBF,1
ListBox$(Result:,2)
waitkey
Created with SQLEXEC The Error Message can Objekt KURSPROGRAMM.DBF not find
What do I do wrong? A& <> 0 !!!!!!!!!!!! |
|
| |
| |
| |
|
(863)
Deutsch
English
Français
Español
Italia