有人在Android上用UniDAC 6.2.7连接MySQL吗?有没有遇到UniQuery和UniTable打开极慢?

baby_moon

Registered
Registered
注册
2015-10-06
消息
3
UniConnection在Connected设为True的时候很快,但是用Connect就很慢,甚至弹出异常,Table和UniQuery就极慢。

有谁遇过吗?有没有解决办法?
 
Hello there,

Could it help if I got a full version of UniDac?

Thank you
 
i have try full version of unidac can handle the direct connection through sql server, so it not be matter if it used mysql
just dont forget to drop the mysql provider on the form to make sure that the mysql working correctly
 
unidac 7.0.1在android连接sqlite3数据库有BUG,只能读不能写,一写就提示disk i/o error错误。
 
unidac 7.0.1在android连接sqlite3数据库有BUG,只能读不能写,一写就提示disk i/o error错误。
有可能是数据库文件的权限问题,把数据库复制到可写的位置试试
 
来学习,delphi7 用都视bde,貌似现在不能用来。
应该用哪个数据控件来开发呢?
 
For a good operation of Database projects using RAD Studio (Delphi / CBuilder) + UNIDAC or FIREDAC:

1) make your project thinking about the next possibilities of database change

2) In the database use names of tables and fields that can be understood by any database. use maximum size names as allowed by all database, usually 31 ASCII characters. In the same way, for the name of the columns.

3) In the UniDAC / FireDAC project use the common components: dbConnection, dbWaitCursor, dbQuery, dbDataSource, etc ... more are proper components for each Framework as FireDAC / UniDAC xxxPhysxxxDriversxxx

4) If possible, use MACRO replacement in the confections of the connections or querys. This way, your project will be ready for any database change.

5) Be careful not to overcomplicate your project with excess macro overwriting table names or fields.

6) If your project also serves for MOBILE use DIRECTIVES for each platform, each platform must have its definitions and forms in different units.
Use the directives through, for example:
{IFDEF ANDROID} code {ENDIF}
see {INCLUDE xxxx.pas} or {i xxxx.pas} or any text file with Delphi code.

7) To embed files next to your project, look for using OPTION, DEPLOIMENT options so that the necessary ones for your application are sent to the appropriate installation locations. See the RAD STUDIO help manual (or the Embarcadero online manual) for each platform's standard variables to install additional files from your application, such as the database in MOBILE / Windows / Linyx / macOS environments

This makes maintenance easy, if necessary.
对于使用RAD Studio(Delphi / CBuilder)+ UNIDAC或FIREDAC的数据库项目的良好操作:

1)让你的项目考虑数据库变化的下一个可能性

2)在数据库中使用任何数据库都可以理解的表和字段的名称。使用所有数据库允许的最大大小名称,通常为31个ASCII字符。以同样的方式,为列的名称。

3)在UniDAC / FireDAC项目中,使用通用组件:dbConnection,dbWaitCursor,dbQuery,dbDataSource等...更多适用于每个框架的组件,如FireDAC / UniDAC xxxPhysxxxDriversxxx

4)如果可能的话,在连接或查询的甜食中使用MACRO替换。这样,您的项目将准备好进行任何数据库更改。

5)注意不要使用多余的宏覆盖表名称或字段来过度复杂项目。

6)如果您的项目也为每个平台的MOBILE使用DIRECTIVES服务,则每个平台必须以不同的单位定义和表格。

通过使用指令,例如:

{IFDEF ANDROID}代码{ENDIF}
使用Delphi代码查看{INCLUDE xxxx.pas}或{i xxxx.pas}或任何文本文件。

7)要将文件嵌入到项目旁边,请查找使用OPTION,DEPLOIMENT选项,以便为您的应用程序发送必要的文件到相应的安装位置。有关每个平台的标准变量,请参阅RAD STUDIO帮助手册(或Embarcadero在线手册),以从您的应用程序安装其他文件,例如MOBILE / Windows / Linyx / macOS环境中的数据库

如有必要,这使维护变得容易。
1523662651973.png
1523663241574.png

Returns either the home path of the user or the application's writable scratch directory or storage:
http://docwiki.embarcadero.com/Libraries/Tokyo/en/System.IOUtils.TPath.GetHomePath

http://docwiki.embarcadero.com/RADS...Multi-Device_Application_on_Desktop_Platforms
http://docwiki.embarcadero.com/RADS...eDAC_in_Mobile_Applications_(iOS_and_Android)
http://docwiki.embarcadero.com/RADS...terBase_ToGo_with_dbExpress_(iOS_and_Android)

How to Develop Android Database Applications in RAD Studio XE5 (Posted by DAC Team on October 8th, 2013) - VERY GOOD
see about "Deployment to mobile device"
http://blog.devart.com/android-database-application-development-in-rad-studio-xe5.html

UniDAC dramatically slow in wireless network
https://forums.devart.com/viewtopic.php?t=20521

UniDAC and FireDAC in the same Android app?
https://forums.devart.com/viewtopic.php?t=35714

How to access MySQL database on local computer with Android App?
https://forums.devart.com/viewtopic.php?t=35737

Designing Android apps to handle slow network speed (by Tosin Onikute)
https://android.jlelse.eu/designing-android-apps-to-handle-slow-network-speed-dedc04119aac
 
最后编辑:

Similar threads

S
回复
0
查看
3K
SUNSTONE的Delphi笔记
S
S
回复
0
查看
2K
SUNSTONE的Delphi笔记
S
D
回复
0
查看
840
DelphiTeacher的专栏
D
后退
顶部