FOROS PROFESIONALES
WINDEV
,
WEBDEV
y
WINDEV Mobile
Inicio
|
Mensajes recientes
|
Conéctese...
|
Desconectar
|
Español
Inicio
→
WINDEV 2024
→
Extremely poor MySQL performance issues when using HAdd
Extremely poor MySQL performance issues when using HAdd
Iniciado por Pascal Scheffers, 30,jun. 2004 10:19 - 3 respuestas
Conéctese…
Pascal Scheffers
#1
Publicado el 30,junio 2004 - 10:19
Hi,
I have a MySQL database, and I am using the HAdd function to add new records to a table. The table has some char and integer fields and two fields with a unique index.
Adding records get progressively slower and slower - with 100 records is runs at roughly 1000 inserts per minute, at 1000 records in the table it runs at rougly 300 inserts a minute and at 10000 records in the table, it drops to 1 per second...
When I run the same code on a hyper file with the exact same definition it starts out at 1500 record adds a minute, and doesn't slow down a bit.
What is happening? It is not a mysql issue, I think - doing an insert into that table from the mysql> prompt is very very fast. My gut feeling is that the pcsoft mysql driver is loading all rows for a column from the mysql table for each insert.
Is there another function I should use? SQLAdd or something?
- Pascal.
Informar
0
0
joe crevino
#2
Publicado el 30,junio 2004 - 15:27
Have you tried creating a query in windev using the insert format ?
joe
Informar
0
0
Pascal Scheffers
#3
Publicado el 30,junio 2004 - 17:20
Have you tried creating a query in windev using the insert format ?
joe
Well, not in Windev, but by hand - and that was, like I said, very fast.
If I can't find a solution just write my own HSQLAdd function, which will do just that. Although I'd like to avoid having to handle the various SQL quoting and date/time conversion issues...
- Pascal.
Informar
0
0
joe crevino
#4
Publicado el 30,junio 2004 - 17:42
I have found certain issue with mysql and windev. But as you describe hand coding usually is a very easy fix...but not a quick fix
joe
Informar
0
0
→ Volver a WINDEV 2024
WINDEV 2024
WEBDEV 2024
WINDEV Mobile 2024
WINDEV (versiones precedentes)
Français
English
Español
Portuguesa
Fermer cette fenêtre
Búsqueda Tipo
Sólo temas
Todos los mensajes
Periodo Buscar
Cualquier fecha
Última hora
Última 24 horas
Última semana
Último mes
Último año
Cancelar
Vista previa del mensaje
Añadiendo una imagen
Importar una imagen desde una URL
Enviar una imagen desde un archivo de su disco
Arrastrar un archivo o click en "Examinar..."
o
Cancelar
0%
WLanguage
SQL
XML, HTML
JAVA, Javascript
Texto