Oct
22
asked Which way is it better to call ORM methods in Odoo 7?
Sep
22
awarded Notable Question
Jun
17
awarded Popular Question
Apr
3
awarded Tumbleweed
Mar
27
asked HTTP GET Binding in WSDL not WS-I compliant
Mar
17
accepted OpenERP How to use a domain filter on many2one field?
Mar
17
answered OpenERP How to use a domain filter on many2one field?
Mar
14
asked OpenERP How to use a domain filter on many2one field?
Mar
23
awarded Teacher
Jan
11
answered PhoneGap Getting Started with Android "Missing one of the following"
Apr
29
asked Create a stateful session bean from a stateless bean
Aug
9
awarded Scholar
Aug
9
comment MySql Query very slow
@Dems let us continue this discussion in chat
Aug
9
accepted MySql Query very slow
Aug
9
comment MySql Query very slow
I first added id_dernier_fichier at the end of my index. I moved it first and now it works ! I will see how my insert and update statements execute but thank you for your help, it works now !
Aug
9
awarded Supporter
Aug
9
comment MySql Query very slow
It is the only query I have that runs so slow. If it can drammatically improve the speed, and if it does not drammatically decrease the speed of inserts and updates, I think it is worth creating those indexes. But I already created an index that covers all the fields used in the query (IDX_TousLesFous), what do I have to add ?
Aug
9
comment MySql Query very slow
I updated my question with all information.
Aug
9
comment MySql Query very slow
@Dems It is unique but can be NULL
Aug
9
comment MySql Query very slow
I use InnoDB. However id_dernier_fichier is not the primary key, so how do I set it as a clustered index ?
1 2