473,324 Members | 2,400 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,324 software developers and data experts.

Base MySQL par defaut (plutot que mysql_select_db())

Bonjour,

Est-il possible de se passer de l'instruction mysql_select_db() afin
de sélectionner une base de données par défaut dans MySQL ?

Je pense en particulier à l'association d'une base par défaut à un
utilisateur comme cela est possible dans Oracle ou SQL Server.

En effet, l'appel de cette fonction déclenche un nombre non
négligeable de requêtes sur la base (requêtes "change db").

Merci d'avance pour vos idées.
Jul 17 '05 #1
3 3340
Personne n'a une idée ? Est-ce vraiment la seule solution ???

Mes mesures sur la base de données montrent que 16% des requêtes de
l'appli sont pour réaliser cette commande !

26*******@sneakemail.com (Oliv) wrote in message news:<fd**************************@posting.google. com>...
Bonjour,

Est-il possible de se passer de l'instruction mysql_select_db() afin
de sélectionner une base de données par défaut dans MySQL ?

Je pense en particulier à l'association d'une base par défaut à un
utilisateur comme cela est possible dans Oracle ou SQL Server.

En effet, l'appel de cette fonction déclenche un nombre non
négligeable de requêtes sur la base (requêtes "change db").

Merci d'avance pour vos idées.

Jul 17 '05 #2
Dans la configuration de MySQL on a les champs suivants :

MySQL.allow_persistent
MySQL.default_host
MySQL.default_password
MySQL.default_port
MySQL.default_socket
MySQL.default_user
MySQL.max_links
MySQL.max_persistent

mais n'existe-t'il pas un champs default_instance ?
26*******@sneakemail.com (Oliv) wrote in message news:<fd**************************@posting.google. com>...
Personne n'a une idée ? Est-ce vraiment la seule solution ???

Mes mesures sur la base de données montrent que 16% des requêtes de
l'appli sont pour réaliser cette commande !

26*******@sneakemail.com (Oliv) wrote in message news:<fd**************************@posting.google. com>...
Bonjour,

Est-il possible de se passer de l'instruction mysql_select_db() afin
de sélectionner une base de données par défaut dans MySQL ?

Je pense en particulier à l'association d'une base par défaut à un
utilisateur comme cela est possible dans Oracle ou SQL Server.

En effet, l'appel de cette fonction déclenche un nombre non
négligeable de requêtes sur la base (requêtes "change db").

Merci d'avance pour vos idées.

Jul 17 '05 #3

Non. Le travail qui est effectué par MYSQL pour choisir une base de
données doit être effectué indépendamment de comment la base de
données choisir est indiquée. Les frais généraux sont dus à
l'information de chargement de MYSQL des tables de système concernant
la base de données demandée, et ceci sera toujours exigé.

(Translation courtesy of Google, apologies if it is now complete
nonsense, it was meaningful when I started!)

---
Steve

Jul 17 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Don Rozenberg | last post by:
Hello, I'm successfully running MySql under Debian with the data files in /var/lib/mysql. I would like to move the data base files to my home directory and have mysql use them from there. How...
3
by: Leonardo Javier Bel?n | last post by:
I cannot make the following program call the MYSQL C API when called from the function process_token and I dont know why. I checked the WEB and I did found nothing related to this bug. I am using...
0
by: DevBoy | last post by:
I installed the base MySQL 4.0 with Suse Linux and I try and start it and I get anb issue with the fact that mysql.sock file does not exist in /etc..../mysql/mysql.sock I created a file and made...
0
by: Forecast | last post by:
I am using the MySQL++, MySQL 4 in MS Visual C++ 6.0. When I try to compile the program, warning occurs (see below). Besides, the program have runtime error as follows: "The procedure entry point...
6
by: AP | last post by:
I have not seen any good examples on how to connect to a mySQL db. My website uses phpMyAdmin to administer the SQL databases. What confuses me is where are the databases that I create located? For...
2
by: msnews.microsoft.com | last post by:
Hi Here is another EASY question When you serialise an object in .NET, serialisation adds defaut attributes that I dont care EXEMPLE : <root_test...
4
by: Lighter | last post by:
Why is template function not allowed to have defaut arguments? We know that class template is allowed to have default arguments in C++ standard, why is template function not? I can't think out...
0
Coldfire
by: Coldfire | last post by:
Since i cannot show the differences in a two-column like table. I am first putting MS SQL Server 2005 and then MySQL 5.x. MS SQL Server 2005 Brief Overview - SQL Server is a full-fledged...
5
by: Vik Rubenfeld | last post by:
Is there a way to import an MS Access database .mdb file into MySQL running locally on a Mac? Thanks in advance to all for any info.
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.