1

Topic: Acceess and MySQL (long plunges)

Prompt please;
There is a DB of Akses a separate file , all on  a computer, works quickly and well!
Transferred a DB on MySQL, works slowly... In what there can be a reason?

2

Re: Acceess and MySQL (long plunges)

SergeyL1986 wrote:

Prompt please;
There is a DB of Akses a separate file , all on  a computer, works quickly and well!
Transferred a DB on MySQL, works slowly... In what there can be a reason?

For certain at you the table  under the rights of the manager of the server, with all access to all functions. It brakes system at project discovery.
C the new user only with the rights on SELECT, INSERT, UPDATE, DELETE, FILE in phpMyAdmin within the limits of your database on server MySQL. Remaining resolutions do not do. And  / copy login and the password in MySQL odbc driver in section of administration of data sources odbc.
It should accelerate operation.
And so that is subjective, if you on one computer  basis, not in a multiple user mode it is not necessary any MySQL. A priori through MySQL odbc driver ms access will boot more slowly.
Advantage MySQL can see only when nearby 50 the person will work simultaneously in basis from different computers. It also will be at discovery hardly , but with the same speed, as well as at one person) But the basis only in  at such amount of users will be  and  disastrously.

3

Re: Acceess and MySQL (long plunges)

Thanks, I will be !
As to a DB, My SQl becomes in view of that operation from a DB to have from different Cities, other decision that did not invent that)
If there are ideas share please.

4

Re: Acceess and MySQL (long plunges)

SergeyL1986 wrote:

Thanks, I will be !
As to a DB, My SQl becomes in view of that operation from a DB to have from different Cities, other decision that did not invent that)
If there are ideas share please.

So ideas and lots of plans! ()
You tell, how at you remote users from other cities communicate with basis? Directly through the Internet, where as the server it is specified IP your computer where to be twisted the basis on mysql, or is simple in a remote access mode at first come on a desktop of your computer, and then already therefrom launch a label ?

5

Re: Acceess and MySQL (long plunges)

Sergey Lalov;
Now, it is made very much a top ))) in a network to steam of computers  from a DB, but there are other computers which out of a network but there is an access in . Here they should give access to a DB. Here also solved on MySQL (the address constant, in forms  to register only a way/DSN to adjust and it is ready)
And what variants still are?

6

Re: Acceess and MySQL (long plunges)

SergeyL1986 wrote:

Transferred a DB on MySQL, works slowly... In what there can be a reason?

Earlier you worked on built in native , on it and were quickly, - MySQL absolutely another, moreover through the Internet... Here it is necessary to change completely ideology, it is necessary to do most a certain similarity vb-net... One project works for me with periphery on USB megaphone modems but that it costed... In general if bluntly tables from mdb to throw in mysql most likely the hogwash (in  still so tolerably and at great volumes can also the scoring turns out but if through the Internet - that precisely hogwash) turns out. Through the Internet to use MySql that is interesting as a clipboard between the cores local , yes, only because a freebie...

7

Re: Acceess and MySQL (long plunges)

vmag;
Well here business in speed of the Internet most likely, at me by enough bright machine with a rate 100mb/sek is quite efficient was tested. Checked so, I for the server in Moscow, .. And two client parts are delivered in Peter and Ekaterinburg. Normally, . Communication excellent. As I wrote pair of the moments which accelerate operation it a little above - to create the user with the trimmed rights, and the second moment - not to use Inno DB, and to use MyIsam at creation of tables. Very tolerably. Now the Internet cheap and high-speed) Used as assembly MySQL dial-up WAMP server. (It is simple as .)

8

Re: Acceess and MySQL (long plunges)

For acceleration it is necessary to minimize first of all the traffic between the server and the client. For this purpose decent alterations of application, transfer what only can be demanded is possible logicians on the server through procedures/triggers, to use pass-through requests instead of  tables, to add caching of reference tables, sometimes, if probably, caching of the main tables - in general is added also, operations can be demanded much.

9

Re: Acceess and MySQL (long plunges)

wrote:

And what variants still are?

If only from this that at you is to refuse from  and to alter all on server requests, editings to issue a call  and ...
To work through an Internet with  tables... Put at all in brakes, and in stability of the channel. Will work, a question in how it will work under loading.
At you  simply sticks out outside?

10

Re: Acceess and MySQL (long plunges)

... The previous message did not behold,  for repetition idei:-)

11

Re: Acceess and MySQL (long plunges)

Inno DB and to use MyIsam
I will try)))
All thanks for councils!

12

Re: Acceess and MySQL (long plunges)

bubucha;
Prompt please, in  there is a possibility  tables from MySQL (that I and made now). And here from Vba to make connection I so I understand it absolutely another? You could not allow primer/share information how to make connection with MySQL through .

13

Re: Acceess and MySQL (long plunges)

Children, connectors of the last versions by default  the information. There many interesting buns in adjustments.
And with connection is floppy enough work, and cursors support, and  the data, and it is a lot of that else
On a site of developers there are even recommended parameters for operation with ms access, ms sql server e.t.c.
Here the detailed description of all properties/svistoperdelok of the given connector, from a plow so to say:
HERE 
It is possible as in the code all of them to set, and simply ticks  in the standard visualized type if it is simple .)
[img=http://123.png]

14

Re: Acceess and MySQL (long plunges)

SergeyL1986 wrote:

with MySQL through

That not :
- For the first time you anchor hands through communication with tables odbc and you tick off to save passwords
- Then it is already possible so:
[spoiler]
Public Sub del_tbl1 () ' switch-off
On Error Resume Next
DoCmd. DeleteObject acTable, "tbl1"
End Sub
Public Function linc_tbl1 () as Integer ' connection
On Error GoTo er1
linc_tbl1 = 0
DoCmd. TransferDatabase acLink, "ODBC", "ODBC; DSN=NameBD", acTable, "tbl1", "tbl1"
Exit Function
er1:
error1 = 1
MsgBox "a connection Error to the server (tbl1)!"
End Function
[/spoiler]
Not to soar a brain, before each connection it is better to do switch-off

15

Re: Acceess and MySQL (long plunges)

SergeyL1986 wrote:

bubucha;
Prompt please, in  there is a possibility  tables from MySQL (that I and made now). And here from Vba to make connection I so I understand it absolutely another? You could not allow primer/share information how to make connection with MySQL through .

Here it is is specific on a muscle there is no code for , there is a piece of a class for testing of a connection with postgresql that the essence is not changed... Here actually

Function Connect () As Boolean
Const str_sql = "SELECT NOW () AS SERVER_TIME"
' Dim str_connect As String
Dim res As Boolean
Dim tmp_q As QueryDef
Dim tmp_r As RecordSet
Dim tmp_db As DAO.Database
On Error GoTo i_error
res = False
If Not WMIPing (db.host) Then
log ("Postgres. Connect ERROR" AND db.host AND "ping error")
Connect = res
Exit Function
End If
str_connect = "ODBC; DRIVER = {PostgreSQL Unicode}; DATABASE =" AND db.name AND ";"
str_connect = str_connect AND "SERVER =" AND db.host AND ";"
str_connect = str_connect AND "UID =" AND db.user AND ";"
str_connect = str_connect AND "PWD =" AND db.pass AND ";"
str_connect = str_connect AND "PORT =" AND db.port AND ";"
str_connect = str_connect AND "CA=d;A6=;A7=100;A8=4096;B0=255;B1=8190;BI=0;C2=dd_;;CX=1c20502bb;A1=7.4;"
Set tmp_db = CurrentDb
Set tmp_q = tmp_db. CreateQueryDef ("")
With tmp_q
.Connect = str_connect
.sql = str_sql
End With
Set tmp_r = tmp_q. OpenRecordset
last_answer = tmp_r. Fields! [SERVER_TIME]
res = True
ClearErr
i_exit:
tmp_q. Close
Set tmp_q = Nothing
Set tmp_db = Nothing
Connect = res
Exit Function
i_error:
last_err_num = Err. Number
last_err_descr = Err. Description
Resume i_exit
End Function

16

Re: Acceess and MySQL (long plunges)

Simply for the sake of experiment created a DB and connected to server MySQL with guest access.  with a driver named instance, therefore it is simply possible to download and try to launch. A format accdb. Tables MyIsam. Columns 13, records about 60000 thousand.
!!! If drivers MYSQL on the computer are not present, beforehand it is necessary to install them FROM HERE and only then to open . Put at once and 64 and 32
The server is in .. Will work today hours till 24.00 Moscow time)

17

Re: Acceess and MySQL (long plunges)

Sergey Lalov;
Works like as quickly if to speak that draws out 60000 lines (8-12 seconds opens the form fm-monitoring (from the moment of start)), at me 150 records (demo), and pulls that that long...

18

Re: Acceess and MySQL (long plunges)

Thanks for an example

19

Re: Acceess and MySQL (long plunges)

SergeyL1986 wrote:

Thanks for an example

.) it at first yes, spends for loading  time. But then speed same as well as in normal  after the basis booted. The connector caches tables. And by the way at the following loading on idea should be faster.

20

Re: Acceess and MySQL (long plunges)

By the way parallely the film is swung, and the son in overwatch played, so loading on the computer not especially and big at mysql.)