autoembeddings very slow performance

General Discussions - English
1

We defined an RT table in plain mode with auto-embeddings as:

table rt_products {
type = rt
path = /var/lib/manticore/rt
rt_field = name

rt_field = spc

rt_attr_float_vector = emb_vector
knn = {“attrs”:\[{“name”:“emb_vector”,“type”:“hnsw”,“hnsw_similarity”:“L2”,“hnsw_m”:16,“quantization”:“8bit”,“hnsw_ef_construction”:200,“model_name”:“sentence-transformers/all-MiniLM-L6-v2”,“from”:“name,spc”}\]}
}

Now we are inserting 10 records into the table, the spc field is a text field and contains a document (converted to text), this is an example of the insert statement:

INSERT INTO rt_products (name,  spc) VALUES (‘0.18 % W/V SODIUM CHLORIDE AND 4 % W/V GLUCOSE IN
T’, ’ \\n\\nIRISH MEDICINES BOARD ACTS 1995 AND 2006\\n\\nMEDICINAL PRODUCTS(CONT
ROL OF PLACING ON THE MARKET)REGULATIONS,2007\\n\\n(S.I. NO.540 OF 2007)\\n\\nPA0179/003/006A\\n\\nCase No: 2041821\\n\\nThe Irish Medicines Board in exercise
of the powers conferred on it by the above mentioned Regulations hereby grants to\\n\\nB. BRAUN MEDICAL LIMITED\\n\\n3 NAAS ROAD INDUSTRIAL PARK, DUBLIN
12, IRELAND\\n\\nan authorisation, subject to the provisions of the said Regulations, in respect of the product\\n\\n0.18 % W/V SODIUM CHLORIDE AND 4 % W/
V GLUCOSE INTRAVENOUS INFUSION BP SOLUTION FOR INFUSION, 500 ML AND 1000 ML\\n\\nThe particulars of which are set out in Part I and Part II of the attac
hed Schedule. The authorisation is also subject to the general conditions as\\n\\nmay be specified in the said Regulations as listed on the reverse of t
his document.\\n\\nThis authorisation, unless previously revoked, shall continue in force from 01/04/2008.\\n\\nSigned on behalf of the Irish Medicines Bo
ard this\\n\\n_______________\_\\n\\nA person authorised in that behalf by the said Board.\\n\\nIRISH MEDICINES BOARD\\n\\n___________________________________\_
***\\n\\n_Date Printed 08/04/2008***\*\*\\n\\n_CRN 2041821\\n\\n_page number: 1
\\n\\nPART II\\n\\nSUMMARY OF PRODUCT CHARACTERISTICS\\n\\n1 NAME OF THE MEDICINAL PRODUCT\\n\\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Inf
usion BP, Solution for Infusion.\\n\\n2 QUALITATIVE AND QUANTITATIVE COMPOSITION\\n\\nFor a full list of excipients, see section 6.1.\\n\\n3 PHARMACEUTICAL
FORM\\n\\nSolution for infusion\\n\\nA clear, colourless, sterile and non-pyrogenic aqueous solution.\\n\\n4 CLINICAL PARTICULARS\\n\\n4.1 THERAPEUTIC INDICAT
IONS\\n\\nFor use in prophylactic and replacement therapy requiring the use of glucose and sodium chloride.\\n\\n4.2 POSOLOGY AND METHOD OF ADMINISTRATION
\\n\\n4.2.1 DOSAGE\\n\\nIn accordance with fluid, electrolyte and energy requirements:\\n\\nNot more than 40 ml/kg body weight per day, corresponding to 1.7
g glucose/kg body weight per day.\\n\\n_Infusion and drop rate:\\n\\nNot more than 5 mg/kg body weight per hour, corresponding to 0.2 g glucose/kg body
weight per hour, or not more\\n\\nthan 1.7 drops/kg weight per minute.\\n\\nThe solution contains per\\n\\n500 ml\\n\\n1000 ml\\n\\nSodium chloride\\n\\n0.90 g\\n
n1.80 g\\n\\nAnhydrous Glucose\\n\\n20.00 g\\n\\n40.00 g\\n\\nas Glucose Monohydrate\\n\\nEach litre provides:\\n\\nElectrolytes:\\n\\nSodium\\n\\n31\\n\\nmmol/l\\n\\nChl
oride\\n\\n31\\n\\nmmol/l\\n\\nCalorific value:\\n\\n668 kJ/1 = 160 kcal/1\\n\\nTheoretical osmolarity:\\n\\n284\\n\\nmOsm/l\\n\\nTitration acidity (to pH 7.4):\\n\\n<
0.5 mmol/l\\n\\npH:\\n\\n3.5 – 5.5\\n\\nIRISH MEDICINES BOARD\\n\\n\*\*\_***\_
\\n\\n_Date Printed 08/04/2008***\*\*\\n\\n_CRN 2041821\\n\\n_page number: 2\\n\\n4.2.2 METHOD AND ROUTE OF ADMINISTRATION\\n\\nIntrave
nous infusion.\\n\\n4.3 CONTRAINDICATIONS\\n\\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Infusion BP, solution for Infusion should not be
used\\n\\nin cases of:\\n\\n- Hyperhydration states.\\n\\n- Hypotonic dehydration with hyponatraemia.\\n\\n- Hypokalaemia.\\n\\n- Impaired kidney function.\\n\\n
This container contains a significant volume of air. To avoid risk of air embolism, this product must not be\\n\\nadministered by pressure infusion.\\n\\n
4.4 SPECIAL WARNINGS AND PRECAUTIONS FOR USE\\n\\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Infusion B.P. Solution for Infusion should
only be\\n\\nadministered with caution in cases of insulin refractory hyperglycaemia necessitating the administration of more than 6\\n\\nunits of insulin
/hour.\\n\\nIt is necessary to monitor the serum electrolytes and water balance.\\n\\nIn post-operative and post-traumatic conditions and in conditions of
impaired glucose tolerance: only administer with\\n\\nmonitoring of blood glucose level.\\n\\nSpecial attention should be paid to regular monitoring of t
he serum potassium concentration.\\n\\n4.5 INTERACTION WITH OTHER MEDICINAL PRODUCTS AND OTHER FORMS OF INTERACTION\\n\\nThe solution should not be admini
stered through the same infusion equipment simultaneously, before or after an\\n\\nadministration of blood because of the possibility of pseudo-agglutin
ation.\\n\\n4.6 PREGNANCY AND LACTATION\\n\\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Infusion BP Solution for Infusion can be used as\\n
\\nindicated.\\n\\n4.7 EFFECTS ON ABILITY TO DRIVE AND USE MACHINES\\n\\nNot applicable.\\n\\n4.8 UNDESIRABLE EFFECTS\\n\\nNone to be expected if used in accordance with the instructions given.\\n\\nIRISH MEDICINES BOARD\\n\\n\*\*\_***\_\\n\\n_Date Printed 08/04/2008\_\\n\\n_CRN 2041821\_\\n\\n_page number: 3\_\\n\\n4.9 OVERDOSE\\n\\n4.9.1 SYMPTOMS\\n\\nOverdose may result in overhydration with increased skin tension, venous congestion, oedema - possibly also lung or\\n\\nbrain oedema, hypokalaemia and acid-base imbalances and hyperglycaemia.\\n\\nClinical symptoms of water intoxication may also occur, such as nausea, vomiting, spasms.\\n\\n4.9.2 EMERGENCY TREATMENT; ANTIDOTES\\n\\nImmediate cessation of infusion, administration of diuretics with continuous monitoring of serum electrolytes,\\n\\ncorrection of electrolyte and acid-base imbalances, administration of insulin if necessary.\\n\\n5 PHARMACOLOGICAL PROPERTIES\\n\\n5.1 PHARMACODYNAMIC PROPERTIES\\n\\nThe solution contains equimolar proportions of sodium and chloride corresponding to one fifth the physiological\\n\\nconcentration in the plasma. In addition this solution also contains 4 % (w/v) of carbohydrate in the form of glucose.\\n\\nThe solution is mainly intended to supply free water in cases of dehydration.\\n\\n5.2 PHARMACOKINETIC PROPERTIES\\n\\nThe total sodium content of the body is ca. 80 mmol/kg of which ca. 97 % is extracellular and ca. 3 % intracellular.\\n\\nThe daily turnover is ca. 100-180 mmol (corresponding to 1.5-2.5 mmol/kg body weight).\\n\\nChloride is exchanged for hydrogen carbonate in the tubule system and is, thus, involved in the regulation of the acid\\n\\nbase balance.\\n\\nOn infusion glucose is first distributed in the intravascular space and then is taken up into the intracellular space.\\n\\nIn glycolysis glucose is metabolized to pyruvate or to lactate. Lactate can be partially re-introduced into the glucose\\n\\nmetabolism (Cori cycle). Under aerobic conditions pyruvate is completely oxidized to carbon dioxide and water. The\\n\\nfinal products of the complete oxidation of glucose are eliminated via the lungs (carbon dioxide) and the kidneys\\n\\n(water).\\n\\n5.3 PRECLINICAL SAFETY DATA\\n\\nThere are no pre-clinical data of relevance to the prescriber which are additional to those already stated in other\\n\\nsections of the SPC.\\n\\n6 PHARMACEUTICAL PARTICULARS\\n\\n6.1 LIST OF EXCIPIENTS\\n\\nWater for injections\\n\\n6.2 INCOMPATIBILITIES\\n\\nWhen mixing with other medicaments it should be remembered that 0.18 % w/v Sodium Chloride and 4 % w/v\\n\\nGlucose Intravenous Infusion BP Solution for Infusion has an acid pH which can cause precipitation in the mixture.\\n\\nIRISH MEDICINES BOARD\\n\\n***\_***\_\\n\\n_Date Printed 08/04/2008\_\\n\\n_CRN 2041821\_\\n\\n_page number: 4\_\\n\\n6.3 SHELF LIFE\\n\\nUnopened: 3 years\\n\\nOnce opened: Use immediately. Discard any unused contents.\\n\\n6.4 SPECIAL PRECAUTIONS FOR STORAGE\\n\\nDo not store above 25°C. Store in original container.\\n\\n6.5 NATURE AND CONTENTS OF CONTAINER\\n\\nContainers of low-density polyethylene with integral on-welded closure of the same material. The closure contains a\\n\\nrubber disc.\\n\\nContents: 500 ml, 1000 ml.\\n\\n6.6 SPECIAL PRECAUTIONS FOR DISPOSAL AND OTHER HANDLING\\n\\nSingle-dose container. Discard unused contents.\\n\\nOnly to be used if the solution is clear, free from visible solid particles and the container or its closure do not show\\n\\nvisible signs of damage.\\n\\n7 MARKETING AUTHORISATION HOLDER\\n\\nB. Braun Medical Limited\\n\\n3 Naas Road Industrial Park\\n\\nDublin 12\\n\\n8 MARKETING AUTHORISATION NUMBER\\n\\nPA 179/3/6\\n\\n9 DATE OF FIRST AUTHORISATION/RENEWAL OF THE AUTHORISATION\\n\\nDate of first authorisation: 01 April 1983\\n\\nDate of last renewal: 01 April 2008\\n\\n10 DATE OF REVISION OF THE TEXT\\n\\nApril 2008\\n\\nIRISH MEDICINES BOARD\\n\\n***\____________________________________________________________________________________\_\\n\\n_Date Printed 08/04/2008\_\\n\\n_CRN 2041821\_\\n\\n_page number: 5\_\\n ');

The problem we have is the time it takes to insert records into the table, about 8 minutes for 10 records, we assume this is caused by the vector calculation (?)

Has anyone performed any benchmarking on this operation so that we can compare ?

Are we doing something wrong ?

As it stands building a table with 5M+ records like the above would not be doable, maybe this is the wrong approach.

Anyone can share benchmarks on using auto-embeddings on many documents, large text maybe with different models ?

2

Hi. I can’t reproduce it with 25.6.0. It took 150ms to insert:

 ~  cat vec.conf
searchd {
    listen = 9315:mysql41
    log = searchd.log
    pid_file = searchd.pid
    binlog_path =
}

table rt_products {
    type = rt
    path = /tmp/vec
    rt_field = name
    rt_field = spc
    rt_attr_float_vector = emb_vector
knn = {"attrs":[{"name":"emb_vector","type":"hnsw","hnsw_similarity":"L2","hnsw_m":16,"quantization":"8bit","hnsw_ef_construction":200,"model_name":"sentence-transformers/all-MiniLM-L6-v2","from":"name,spc"}]}}
}

 ~  searchd -c vec.conf
Manticore 25.6.0 adf0782b5@26041418 dev (columnar 13.2.2 73bde7b@26041402) (secondary 13.2.2 73bde7b@26041402) (knn 13.2.2 73bde7b@26041402) (embeddings 1.1.1 73bde7b@26041402)
Copyright (c) 2001-2016, Andrew Aksyonoff
Copyright (c) 2008-2016, Sphinx Technologies Inc (http://sphinxsearch.com)
Copyright (c) 2017-2026, Manticore Software LTD (https://manticoresearch.com)

[57:42.441] [49462079] using config file '/Users/sn/vec.conf' (450 chars)...
starting daemon version '25.6.0 adf0782b5@26041418 dev (columnar 13.2.2 73bde7b@26041402) (secondary 13.2.2 73bde7b@26041402) (knn 13.2.2 73bde7b@26041402) (embeddings 1.1.1 73bde7b@26041402)' ...
listening on all interfaces for mysql, port=9315
precaching table 'rt_products'
precached 1 tables in 0.667 sec

 ~  mysql -P9315 -h0

mysql> INSERT INTO rt_products (name,  spc) VALUES ('0.18 % W/V SODIUM CHLORIDE AND 4 % W/V GLUCOSE INT', ' \\n\\nIRISH MEDICINES BOARD ACTS 1995 AND 2006\\n\\nMEDICINAL PRODUCTS(CONTROL OF PLACING ON THE MARKET)REGULATIONS,2007\\n\\n(S.I. NO.540 OF 2007)\\n\\nPA0179/003/006A\\n\\nCase No: 2041821\\n\\nThe Irish Medicines Board in exerciseof the powers conferred on it by the above mentioned Regulations hereby grants to\\n\\nB. BRAUN MEDICAL LIMITED\\n\\n3 NAAS ROAD INDUSTRIAL PARK, DUBLIN12, IRELAND\\n\\nan authorisation, subject to the provisions of the said Regulations, in respect of the product\\n\\n0.18 % W/V SODIUM CHLORIDE AND 4 % W/V GLUCOSE INTRAVENOUS INFUSION BP SOLUTION FOR INFUSION, 500 ML AND 1000 ML\\n\\nThe particulars of which are set out in Part I and Part II of the attached Schedule. The authorisation is also subject to the general conditions as\\n\\nmay be specified in the said Regulations as listed on the reverse of this document.\\n\\nThis authorisation, unless previously revoked, shall continue in force from 01/04/2008.\\n\\nSigned on behalf of the Irish Medicines Board this\\n\\n_______________\_\\n\\nA person authorised in that behalf by the said Board.\\n\\nIRISH MEDICINES BOARD\\n\\n___________________________________\_***\\n\\n_Date Printed 08/04/2008***\*\*\\n\\n_CRN 2041821\\n\\n_page number: 1\\n\\nPART II\\n\\nSUMMARY OF PRODUCT CHARACTERISTICS\\n\\n1 NAME OF THE MEDICINAL PRODUCT\\n\\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Infusion BP, Solution for Infusion.\\n\\n2 QUALITATIVE AND QUANTITATIVE COMPOSITION\\n\\nFor a full list of excipients, see section 6.1.\\n\\n3 PHARMACEUTICALFORM\\n\\nSolution for infusion\\n\\nA clear, colourless, sterile and non-pyrogenic aqueous solution.\\n\\n4 CLINICAL PARTICULARS\\n\\n4.1 THERAPEUTIC INDICATIONS\\n\\nFor use in prophylactic and replacement therapy requiring the use of glucose and sodium chloride.\\n\\n4.2 POSOLOGY AND METHOD OF ADMINISTRATION\\n\\n4.2.1 DOSAGE\\n\\nIn accordance with fluid, electrolyte and energy requirements:\\n\\nNot more than 40 ml/kg body weight per day, corresponding to 1.7g glucose/kg body weight per day.\\n\\n_Infusion and drop rate:\\n\\nNot more than 5 mg/kg body weight per hour, corresponding to 0.2 g glucose/kg bodyweight per hour, or not more\\n\\nthan 1.7 drops/kg weight per minute.\\n\\nThe solution contains per\\n\\n500 ml\\n\\n1000 ml\\n\\nSodium chloride\\n\\n0.90 g\\nn1.80 g\\n\\nAnhydrous Glucose\\n\\n20.00 g\\n\\n40.00 g\\n\\nas Glucose Monohydrate\\n\\nEach litre provides:\\n\\nElectrolytes:\\n\\nSodium\\n\\n31\\n\\nmmol/l\\n\\nChloride\\n\\n31\\n\\nmmol/l\\n\\nCalorific value:\\n\\n668 kJ/1 = 160 kcal/1\\n\\nTheoretical osmolarity:\\n\\n284\\n\\nmOsm/l\\n\\nTitration acidity (to pH 7.4):\\n\\n<0.5 mmol/l\\n\\npH:\\n\\n3.5 – 5.5\\n\\nIRISH MEDICINES BOARD\\n\\n\*\*\_***\_\\n\\n_Date Printed 08/04/2008***\*\*\\n\\n_CRN 2041821\\n\\n_page number: 2\\n\\n4.2.2 METHOD AND ROUTE OF ADMINISTRATION\\n\\nIntravenous infusion.\\n\\n4.3 CONTRAINDICATIONS\\n\\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Infusion BP, solution for Infusion should not beused\\n\\nin cases of:\\n\\n- Hyperhydration states.\\n\\n- Hypotonic dehydration with hyponatraemia.\\n\\n- Hypokalaemia.\\n\\n- Impaired kidney function.\\n\\nThis container contains a significant volume of air. To avoid risk of air embolism, this product must not be\\n\\nadministered by pressure infusion.\\n\\n4.4 SPECIAL WARNINGS AND PRECAUTIONS FOR USE\\n\\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Infusion B.P. Solution for Infusion shouldonly be\\n\\nadministered with caution in cases of insulin refractory hyperglycaemia necessitating the administration of more than 6\\n\\nunits of insulin/hour.\\n\\nIt is necessary to monitor the serum electrolytes and water balance.\\n\\nIn post-operative and post-traumatic conditions and in conditions ofimpaired glucose tolerance: only administer with\\n\\nmonitoring of blood glucose level.\\n\\nSpecial attention should be paid to regular monitoring of the serum potassium concentration.\\n\\n4.5 INTERACTION WITH OTHER MEDICINAL PRODUCTS AND OTHER FORMS OF INTERACTION\\n\\nThe solution should not be administered through the same infusion equipment simultaneously, before or after an\\n\\nadministration of blood because of the possibility of pseudo-agglutination.\\n\\n4.6 PREGNANCY AND LACTATION\\n\\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Infusion BP Solution for Infusion can be used as\\n\\nindicated.\\n\\n4.7 EFFECTS ON ABILITY TO DRIVE AND USE MACHINES\\n\\nNot applicable.\\n\\n4.8 UNDESIRABLE EFFECTS\\n\\nNone to be expected if used in accordance with the instructions given.\\n\\nIRISH MEDICINES BOARD\\n\\n\*\*\_***\_\\n\\n_Date Printed 08/04/2008\_\\n\\n_CRN 2041821\_\\n\\n_page number: 3\_\\n\\n4.9 OVERDOSE\\n\\n4.9.1 SYMPTOMS\\n\\nOverdose may result in overhydration with increased skin tension, venous congestion, oedema - possibly also lung or\\n\\nbrain oedema, hypokalaemia and acid-base imbalances and hyperglycaemia.\\n\\nClinical symptoms of water intoxication may also occur, such as nausea, vomiting, spasms.\\n\\n4.9.2 EMERGENCY TREATMENT; ANTIDOTES\\n\\nImmediate cessation of infusion, administration of diuretics with continuous monitoring of serum electrolytes,\\n\\ncorrection of electrolyte and acid-base imbalances, administration of insulin if necessary.\\n\\n5 PHARMACOLOGICAL PROPERTIES\\n\\n5.1 PHARMACODYNAMIC PROPERTIES\\n\\nThe solution contains equimolar proportions of sodium and chloride corresponding to one fifth the physiological\\n\\nconcentration in the plasma. In addition this solution also contains 4 % (w/v) of carbohydrate in the form of glucose.\\n\\nThe solution is mainly intended to supply free water in cases of dehydration.\\n\\n5.2 PHARMACOKINETIC PROPERTIES\\n\\nThe total sodium content of the body is ca. 80 mmol/kg of which ca. 97 % is extracellular and ca. 3 % intracellular.\\n\\nThe daily turnover is ca. 100-180 mmol (corresponding to 1.5-2.5 mmol/kg body weight).\\n\\nChloride is exchanged for hydrogen carbonate in the tubule system and is, thus, involved in the regulation of the acid\\n\\nbase balance.\\n\\nOn infusion glucose is first distributed in the intravascular space and then is taken up into the intracellular space.\\n\\nIn glycolysis glucose is metabolized to pyruvate or to lactate. Lactate can be partially re-introduced into the glucose\\n\\nmetabolism (Cori cycle). Under aerobic conditions pyruvate is completely oxidized to carbon dioxide and water. The\\n\\nfinal products of the complete oxidation of glucose are eliminated via the lungs (carbon dioxide) and the kidneys\\n\\n(water).\\n\\n5.3 PRECLINICAL SAFETY DATA\\n\\nThere are no pre-clinical data of relevance to the prescriber which are additional to those already stated in other\\n\\nsections of the SPC.\\n\\n6 PHARMACEUTICAL PARTICULARS\\n\\n6.1 LIST OF EXCIPIENTS\\n\\nWater for injections\\n\\n6.2 INCOMPATIBILITIES\\n\\nWhen mixing with other medicaments it should be remembered that 0.18 % w/v Sodium Chloride and 4 % w/v\\n\\nGlucose Intravenous Infusion BP Solution for Infusion has an acid pH which can cause precipitation in the mixture.\\n\\nIRISH MEDICINES BOARD\\n\\n***\_***\_\\n\\n_Date Printed 08/04/2008\_\\n\\n_CRN 2041821\_\\n\\n_page number: 4\_\\n\\n6.3 SHELF LIFE\\n\\nUnopened: 3 years\\n\\nOnce opened: Use immediately. Discard any unused contents.\\n\\n6.4 SPECIAL PRECAUTIONS FOR STORAGE\\n\\nDo not store above 25°C. Store in original container.\\n\\n6.5 NATURE AND CONTENTS OF CONTAINER\\n\\nContainers of low-density polyethylene with integral on-welded closure of the same material. The closure contains a\\n\\nrubber disc.\\n\\nContents: 500 ml, 1000 ml.\\n\\n6.6 SPECIAL PRECAUTIONS FOR DISPOSAL AND OTHER HANDLING\\n\\nSingle-dose container. Discard unused contents.\\n\\nOnly to be used if the solution is clear, free from visible solid particles and the container or its closure do not show\\n\\nvisible signs of damage.\\n\\n7 MARKETING AUTHORISATION HOLDER\\n\\nB. Braun Medical Limited\\n\\n3 Naas Road Industrial Park\\n\\nDublin 12\\n\\n8 MARKETING AUTHORISATION NUMBER\\n\\nPA 179/3/6\\n\\n9 DATE OF FIRST AUTHORISATION/RENEWAL OF THE AUTHORISATION\\n\\nDate of first authorisation: 01 April 1983\\n\\nDate of last renewal: 01 April 2008\\n\\n10 DATE OF REVISION OF THE TEXT\\n\\nApril 2008\\n\\nIRISH MEDICINES BOARD\\n\\n***\____________________________________________________________________________________\_\\n\\n_Date Printed 08/04/2008\_\\n\\n_CRN 2041821\_\\n\\n_page number: 5\_\\n ');
Query OK, 1 row affected (0.150 sec)

mysql> select * from rt_products\G
*************************** 1. row ***************************
        id: 868376004236673025
      name: 0.18 % W/V SODIUM CHLORIDE AND 4 % W/V GLUCOSE INT
       spc:  \n\nIRISH MEDICINES BOARD ACTS 1995 AND 2006\n\nMEDICINAL PRODUCTS(CONTROL OF PLACING ON THE MARKET)REGULATIONS,2007\n\n(S.I. NO.540 OF 2007)\n\nPA0179/003/006A\n\nCase No: 2041821\n\nThe Irish Medicines Board in exerciseof the powers conferred on it by the above mentioned Regulations hereby grants to\n\nB. BRAUN MEDICAL LIMITED\n\n3 NAAS ROAD INDUSTRIAL PARK, DUBLIN12, IRELAND\n\nan authorisation, subject to the provisions of the said Regulations, in respect of the product\n\n0.18 % W/V SODIUM CHLORIDE AND 4 % W/V GLUCOSE INTRAVENOUS INFUSION BP SOLUTION FOR INFUSION, 500 ML AND 1000 ML\n\nThe particulars of which are set out in Part I and Part II of the attached Schedule. The authorisation is also subject to the general conditions as\n\nmay be specified in the said Regulations as listed on the reverse of this document.\n\nThis authorisation, unless previously revoked, shall continue in force from 01/04/2008.\n\nSigned on behalf of the Irish Medicines Board this\n\n________________\n\nA person authorised in that behalf by the said Board.\n\nIRISH MEDICINES BOARD\n\n____________________________________***\n\n_Date Printed 08/04/2008*****\n\n_CRN 2041821\n\n_page number: 1\n\nPART II\n\nSUMMARY OF PRODUCT CHARACTERISTICS\n\n1 NAME OF THE MEDICINAL PRODUCT\n\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Infusion BP, Solution for Infusion.\n\n2 QUALITATIVE AND QUANTITATIVE COMPOSITION\n\nFor a full list of excipients, see section 6.1.\n\n3 PHARMACEUTICALFORM\n\nSolution for infusion\n\nA clear, colourless, sterile and non-pyrogenic aqueous solution.\n\n4 CLINICAL PARTICULARS\n\n4.1 THERAPEUTIC INDICATIONS\n\nFor use in prophylactic and replacement therapy requiring the use of glucose and sodium chloride.\n\n4.2 POSOLOGY AND METHOD OF ADMINISTRATION\n\n4.2.1 DOSAGE\n\nIn accordance with fluid, electrolyte and energy requirements:\n\nNot more than 40 ml/kg body weight per day, corresponding to 1.7g glucose/kg body weight per day.\n\n_Infusion and drop rate:\n\nNot more than 5 mg/kg body weight per hour, corresponding to 0.2 g glucose/kg bodyweight per hour, or not more\n\nthan 1.7 drops/kg weight per minute.\n\nThe solution contains per\n\n500 ml\n\n1000 ml\n\nSodium chloride\n\n0.90 g\nn1.80 g\n\nAnhydrous Glucose\n\n20.00 g\n\n40.00 g\n\nas Glucose Monohydrate\n\nEach litre provides:\n\nElectrolytes:\n\nSodium\n\n31\n\nmmol/l\n\nChloride\n\n31\n\nmmol/l\n\nCalorific value:\n\n668 kJ/1 = 160 kcal/1\n\nTheoretical osmolarity:\n\n284\n\nmOsm/l\n\nTitration acidity (to pH 7.4):\n\n<0.5 mmol/l\n\npH:\n\n3.5 – 5.5\n\nIRISH MEDICINES BOARD\n\n**_***_\n\n_Date Printed 08/04/2008*****\n\n_CRN 2041821\n\n_page number: 2\n\n4.2.2 METHOD AND ROUTE OF ADMINISTRATION\n\nIntravenous infusion.\n\n4.3 CONTRAINDICATIONS\n\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Infusion BP, solution for Infusion should not beused\n\nin cases of:\n\n- Hyperhydration states.\n\n- Hypotonic dehydration with hyponatraemia.\n\n- Hypokalaemia.\n\n- Impaired kidney function.\n\nThis container contains a significant volume of air. To avoid risk of air embolism, this product must not be\n\nadministered by pressure infusion.\n\n4.4 SPECIAL WARNINGS AND PRECAUTIONS FOR USE\n\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Infusion B.P. Solution for Infusion shouldonly be\n\nadministered with caution in cases of insulin refractory hyperglycaemia necessitating the administration of more than 6\n\nunits of insulin/hour.\n\nIt is necessary to monitor the serum electrolytes and water balance.\n\nIn post-operative and post-traumatic conditions and in conditions ofimpaired glucose tolerance: only administer with\n\nmonitoring of blood glucose level.\n\nSpecial attention should be paid to regular monitoring of the serum potassium concentration.\n\n4.5 INTERACTION WITH OTHER MEDICINAL PRODUCTS AND OTHER FORMS OF INTERACTION\n\nThe solution should not be administered through the same infusion equipment simultaneously, before or after an\n\nadministration of blood because of the possibility of pseudo-agglutination.\n\n4.6 PREGNANCY AND LACTATION\n\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Infusion BP Solution for Infusion can be used as\n\nindicated.\n\n4.7 EFFECTS ON ABILITY TO DRIVE AND USE MACHINES\n\nNot applicable.\n\n4.8 UNDESIRABLE EFFECTS\n\nNone to be expected if used in accordance with the instructions given.\n\nIRISH MEDICINES BOARD\n\n**_***_\n\n_Date Printed 08/04/2008_\n\n_CRN 2041821_\n\n_page number: 3_\n\n4.9 OVERDOSE\n\n4.9.1 SYMPTOMS\n\nOverdose may result in overhydration with increased skin tension, venous congestion, oedema - possibly also lung or\n\nbrain oedema, hypokalaemia and acid-base imbalances and hyperglycaemia.\n\nClinical symptoms of water intoxication may also occur, such as nausea, vomiting, spasms.\n\n4.9.2 EMERGENCY TREATMENT; ANTIDOTES\n\nImmediate cessation of infusion, administration of diuretics with continuous monitoring of serum electrolytes,\n\ncorrection of electrolyte and acid-base imbalances, administration of insulin if necessary.\n\n5 PHARMACOLOGICAL PROPERTIES\n\n5.1 PHARMACODYNAMIC PROPERTIES\n\nThe solution contains equimolar proportions of sodium and chloride corresponding to one fifth the physiological\n\nconcentration in the plasma. In addition this solution also contains 4 % (w/v) of carbohydrate in the form of glucose.\n\nThe solution is mainly intended to supply free water in cases of dehydration.\n\n5.2 PHARMACOKINETIC PROPERTIES\n\nThe total sodium content of the body is ca. 80 mmol/kg of which ca. 97 % is extracellular and ca. 3 % intracellular.\n\nThe daily turnover is ca. 100-180 mmol (corresponding to 1.5-2.5 mmol/kg body weight).\n\nChloride is exchanged for hydrogen carbonate in the tubule system and is, thus, involved in the regulation of the acid\n\nbase balance.\n\nOn infusion glucose is first distributed in the intravascular space and then is taken up into the intracellular space.\n\nIn glycolysis glucose is metabolized to pyruvate or to lactate. Lactate can be partially re-introduced into the glucose\n\nmetabolism (Cori cycle). Under aerobic conditions pyruvate is completely oxidized to carbon dioxide and water. The\n\nfinal products of the complete oxidation of glucose are eliminated via the lungs (carbon dioxide) and the kidneys\n\n(water).\n\n5.3 PRECLINICAL SAFETY DATA\n\nThere are no pre-clinical data of relevance to the prescriber which are additional to those already stated in other\n\nsections of the SPC.\n\n6 PHARMACEUTICAL PARTICULARS\n\n6.1 LIST OF EXCIPIENTS\n\nWater for injections\n\n6.2 INCOMPATIBILITIES\n\nWhen mixing with other medicaments it should be remembered that 0.18 % w/v Sodium Chloride and 4 % w/v\n\nGlucose Intravenous Infusion BP Solution for Infusion has an acid pH which can cause precipitation in the mixture.\n\nIRISH MEDICINES BOARD\n\n***_***_\n\n_Date Printed 08/04/2008_\n\n_CRN 2041821_\n\n_page number: 4_\n\n6.3 SHELF LIFE\n\nUnopened: 3 years\n\nOnce opened: Use immediately. Discard any unused contents.\n\n6.4 SPECIAL PRECAUTIONS FOR STORAGE\n\nDo not store above 25°C. Store in original container.\n\n6.5 NATURE AND CONTENTS OF CONTAINER\n\nContainers of low-density polyethylene with integral on-welded closure of the same material. The closure contains a\n\nrubber disc.\n\nContents: 500 ml, 1000 ml.\n\n6.6 SPECIAL PRECAUTIONS FOR DISPOSAL AND OTHER HANDLING\n\nSingle-dose container. Discard unused contents.\n\nOnly to be used if the solution is clear, free from visible solid particles and the container or its closure do not show\n\nvisible signs of damage.\n\n7 MARKETING AUTHORISATION HOLDER\n\nB. Braun Medical Limited\n\n3 Naas Road Industrial Park\n\nDublin 12\n\n8 MARKETING AUTHORISATION NUMBER\n\nPA 179/3/6\n\n9 DATE OF FIRST AUTHORISATION/RENEWAL OF THE AUTHORISATION\n\nDate of first authorisation: 01 April 1983\n\nDate of last renewal: 01 April 2008\n\n10 DATE OF REVISION OF THE TEXT\n\nApril 2008\n\nIRISH MEDICINES BOARD\n\n***_____________________________________________________________________________________\n\n_Date Printed 08/04/2008_\n\n_CRN 2041821_\n\n_page number: 5_\n
emb_vector: -0.05682088,0.01891884,-0.02223490,-0.09267817,-0.03007322,0.02999187,0.03913849,0.13553195,0.00603281,-0.03859154,0.02587477,-0.04828537,0.01489859,0.05660653,-0.05838352,-0.02246113,-0.02256906,0.00321696,-0.08840498,0.12384180,0.04808119,0.07290991,-0.01319711,0.08031373,0.00684997,0.01652433,0.01873516,-0.02329353,-0.03266396,-0.01768079,0.04699039,0.06667498,0.04330623,-0.05700230,0.10195064,0.05826750,-0.06465147,-0.03778774,-0.04420565,0.01622240,-0.00923161,-0.04192222,-0.04765630,0.03784487,0.05545688,0.02880659,-0.09251243,-0.03651725,-0.055523,0.08628666,-0.08398955,0.00018773,-0.06667715,0.01772333,0.02178411,-0.09655894,-0.07610108,-0.06480659,-0.02795178,-0.00366168,0.04170473,0.09500621,-0.02435274,0.03378325,-0.00375454,0.00207661,0.03459340,-0.08076896,-0.05221758,-0.00440019,-0.03630441,-0.05738284,0.02270752,0.01825522,-0.00522771,-0.00853332,0.00816909,0.00070432,0.01779481,-0.12781185,0.07095686,0.02236670,-0.00156725,-0.00433256,0.04057904,-0.02887132,-0.02620958,-0.00443356,0.02910857,-0.01717730,0.07398258,0.02233877,0.03094649,-0.02225205,0.06825664,-0.02869855,-0.05426832,-0.00176368,0.05295197,0.01839750,-0.02521705,0.03229163,-0.08059614,-0.03564654,-0.04844620,-0.03111616,0.10495220,0.01132628,0.02887950,0.05546861,0.01295555,0.00388031,0.02627591,-0.06155769,-0.01382491,0.02937210,0.01755594,-0.05499628,0.06725870,0.00452739,-0.01660436,0.04161227,0.00349597,-0.03892493,-0.03869316,0.04460049,0.10123858,0.00000000,-0.02953156,-0.07907787,-0.00407668,-0.01025502,0.02602858,0.03703012,0.04046758,-0.05300196,-0.01846130,-0.04406537,-0.10485818,-0.00260151,-0.04971989,0.05584396,-0.05077297,-0.04089368,0.09167334,0.03082349,0.03941168,-0.02081354,0.08621328,0.01319787,0.02847286,0.06978349,-0.02867154,-0.02072708,-0.05895792,-0.01497201,0.04649711,-0.00027060,0.06371824,-0.05897098,-0.02882272,-0.03639956,-0.08144926,0.01115111,0.00900978,0.01963932,0.05095628,0.05240827,-0.00697861,0.06721040,0.01872337,0.03218300,-0.03395383,-0.03082551,-0.08402708,0.09054858,0.07855651,0.01548907,-0.06057369,-0.00214916,-0.02971181,-0.05218806,0.00670179,0.06078291,-0.10359851,0.05652439,0.01537230,0.04095353,-0.06206682,0.14116791,-0.02346236,-0.02314701,0.04228237,-0.00200460,-0.02633674,-0.08060055,-0.01091606,-0.11186262,-0.11220613,-0.01489572,0.08699113,0.00797289,-0.01302846,-0.02268696,-0.00112288,0.01484130,-0.03349213,-0.09699725,-0.04159690,0.06970158,-0.05803109,0.05397648,-0.07028342,-0.03510398,0.04799866,-0.03750882,-0.06099173,0.01250262,0.01885225,-0.04006547,-0.04808971,-0.04018719,0.02585229,-0.00000000,0.07216821,0.00503421,0.01935717,-0.07160578,0.02578400,0.06063564,0.04074370,-0.13500269,0.00084004,-0.02182860,0.05103353,0.05099796,-0.00840707,-0.06193577,-0.11418778,0.05217122,-0.06807449,0.02285656,-0.03738809,-0.00982042,0.01224338,0.10297379,0.04668227,0.02807944,0.07875587,0.00065225,0.03139344,0.04188284,0.09137329,-0.02488926,-0.00027790,-0.05854436,-0.09659600,0.01116941,-0.05663357,-0.04175900,0.07123911,-0.01058630,-0.07167463,0.00949975,0.07367217,0.03807682,-0.03589744,0.00760887,0.02444993,0.04772044,0.02831625,-0.11076263,0.06603590,-0.07695218,-0.02833233,-0.04147899,0.01941441,0.00233800,-0.03177255,0.04069621,0.02689593,-0.02958432,0.01427301,-0.06457450,0.07638328,0.05143294,0.01131803,-0.11743552,0.04676147,0.00148503,-0.03054398,0.00585658,0.13601206,-0.09093874,-0.05701232,-0.03964101,0.06857759,-0.13205984,0.07556123,-0.01781959,-0.00704778,-0.06441132,0.00506129,-0.06179247,0.00668186,0.05108831,-0.06466342,0.04637576,-0.01057519,-0.07317393,0.05697212,-0.07286499,0.01108797,0.02500476,-0.03316975,-0.00304265,0.00293104,0.05191844,0.05862129,-0.00000005,0.06251815,-0.02121658,-0.03174547,-0.00224282,0.00616758,0.00407253,-0.02350572,-0.03421227,-0.00826670,0.05754791,0.00981433,0.08337006,-0.05895114,-0.01140477,-0.04968928,-0.00482494,-0.10599209,0.05250510,-0.03501718,-0.04054696,0.02566577,0.02683795,-0.05739143,-0.04328577,0.01987295,-0.04036479,-0.03058933,-0.04195019,-0.08616266,0.03204539,0.00668957,0.03807067,0.08386488,-0.02612775,0.02697467,-0.11201502,0.05058692,0.07381877,-0.00594333,0.05919901,-0.04653451,-0.08793318,-0.02868691,0.01693329,0.06068663,-0.02635769,-0.03431673,0.05746682,0.02861277,-0.01744698,0.01783892,-0.00237945,-0.00483130,0.00061063,-0.01812284,0.02991458,-0.05322041,-0.02869571,0.01224263,-0.03215917,-0.01276133,0.03780644,0.07228945,-0.00646896
1 row in set (0.002 sec)
--- 1 out of 1 results in 366us ---

Please try to provide a minimal reproducible example. As you pare it down, you may discover what’s going wrong.

3

Server version: 17.5.1 d4cc0969e@26020616 (columnar 10.2.2 a705ab6@26020918) (secondary 10.2.2 a705ab6@26020918) (knn 10.2.2 a705ab6@26020918) (embeddings 1.1.1) git branch manticore-17.5.1…origin/manticore-17.5.1

INSERT INTO rt_products (name, doc_text) VALUES (‘0.18 % W/V SODIUM CHLORIDE AND 4 % W/V GLUCOSE INT’, ’ \n\nIRISH MEDICINES BOARD ACTS 1995 AND 2006\n\nMEDICINAL PRODUCTS(CONTROL OF PLACING ON THE MARKET)REGULATIONS,2007\n\n(S.I. NO.540 OF 2007)\n\nPA0179/003/006A\n\nCase No: 2041821\n\nThe Irish Medicines Board in exerciseof the powers conferred on it by the above mentioned Regulations hereby grants to\n\nB. BRAUN MEDICAL LIMITED\n\n3 NAAS ROAD INDUSTRIAL PARK, DUBLIN12, IRELAND\n\nan authorisation, subject to the provisions of the said Regulations, in respect of the product\n\n0.18 % W/V SODIUM CHLORIDE AND 4 % W/V GLUCOSE INTRAVENOUS INFUSION BP SOLUTION FOR INFUSION, 500 ML AND 1000 ML\n\nThe particulars of which are set out in Part I and Part II of the attached Schedule. The authorisation is also subject to the general conditions as\n\nmay be specified in the said Regulations as listed on the reverse of this document.\n\nThis authorisation, unless previously revoked, shall continue in force from 01/04/2008.\n\nSigned on behalf of the Irish Medicines Board this\n\n________________\n\nA person authorised in that behalf by the said Board.\n\nIRISH MEDICINES BOARD\n\n____________________________________\n\n_Date Printed 08/04/2008**\n\n_CRN 2041821\n\n_page number: 1\n\nPART II\n\nSUMMARY OF PRODUCT CHARACTERISTICS\n\n1 NAME OF THE MEDICINAL PRODUCT\n\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Infusion BP, Solution for Infusion.\n\n2 QUALITATIVE AND QUANTITATIVE COMPOSITION\n\nFor a full list of excipients, see section 6.1.\n\n3 PHARMACEUTICALFORM\n\nSolution for infusion\n\nA clear, colourless, sterile and non-pyrogenic aqueous solution.\n\n4 CLINICAL PARTICULARS\n\n4.1 THERAPEUTIC INDICATIONS\n\nFor use in prophylactic and replacement therapy requiring the use of glucose and sodium chloride.\n\n4.2 POSOLOGY AND METHOD OF ADMINISTRATION\n\n4.2.1 DOSAGE\n\nIn accordance with fluid, electrolyte and energy requirements:\n\nNot more than 40 ml/kg body weight per day, corresponding to 1.7g glucose/kg body weight per day.\n\n_Infusion and drop rate:\n\nNot more than 5 mg/kg body weight per hour, corresponding to 0.2 g glucose/kg bodyweight per hour, or not more\n\nthan 1.7 drops/kg weight per minute.\n\nThe solution contains per\n\n500 ml\n\n1000 ml\n\nSodium chloride\n\n0.90 g\nn1.80 g\n\nAnhydrous Glucose\n\n20.00 g\n\n40.00 g\n\nas Glucose Monohydrate\n\nEach litre provides:\n\nElectrolytes:\n\nSodium\n\n31\n\nmmol/l\n\nChloride\n\n31\n\nmmol/l\n\nCalorific value:\n\n668 kJ/1 = 160 kcal/1\n\nTheoretical osmolarity:\n\n284\n\nmOsm/l\n\nTitration acidity (to pH 7.4):\n\n<0.5 mmol/l\n\npH:\n\n3.5 – 5.5\n\nIRISH MEDICINES BOARD\n\n**__\n\n_Date Printed 08/04/2008**\n\n_CRN 2041821\n\n_page number: 2\n\n4.2.2 METHOD AND ROUTE OF ADMINISTRATION\n\nIntravenous infusion.\n\n4.3 CONTRAINDICATIONS\n\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Infusion BP, solution for Infusion should not beused\n\nin cases of:\n\n- Hyperhydration states.\n\n- Hypotonic dehydration with hyponatraemia.\n\n- Hypokalaemia.\n\n- Impaired kidney function.\n\nThis container contains a significant volume of air. To avoid risk of air embolism, this product must not be\n\nadministered by pressure infusion.\n\n4.4 SPECIAL WARNINGS AND PRECAUTIONS FOR USE\n\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Infusion B.P. Solution for Infusion shouldonly be\n\nadministered with caution in cases of insulin refractory hyperglycaemia necessitating the administration of more than 6\n\nunits of insulin/hour.\n\nIt is necessary to monitor the serum electrolytes and water balance.\n\nIn post-operative and post-traumatic conditions and in conditions ofimpaired glucose tolerance: only administer with\n\nmonitoring of blood glucose level.\n\nSpecial attention should be paid to regular monitoring of the serum potassium concentration.\n\n4.5 INTERACTION WITH OTHER MEDICINAL PRODUCTS AND OTHER FORMS OF INTERACTION\n\nThe solution should not be administered through the same infusion equipment simultaneously, before or after an\n\nadministration of blood because of the possibility of pseudo-agglutination.\n\n4.6 PREGNANCY AND LACTATION\n\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Infusion BP Solution for Infusion can be used as\n\nindicated.\n\n4.7 EFFECTS ON ABILITY TO DRIVE AND USE MACHINES\n\nNot applicable.\n\n4.8 UNDESIRABLE EFFECTS\n\nNone to be expected if used in accordance with the instructions given.\n\nIRISH MEDICINES BOARD\n\n**__\n\n_Date Printed 08/04/2008_\n\n_CRN 2041821_\n\n_page number: 3_\n\n4.9 OVERDOSE\n\n4.9.1 SYMPTOMS\n\nOverdose may result in overhydration with increased skin tension, venous congestion, oedema - possibly also lung or\n\nbrain oedema, hypokalaemia and acid-base imbalances and hyperglycaemia.\n\nClinical symptoms of water intoxication may also occur, such as nausea, vomiting, spasms.\n\n4.9.2 EMERGENCY TREATMENT; ANTIDOTES\n\nImmediate cessation of infusion, administration of diuretics with continuous monitoring of serum electrolytes,\n\ncorrection of electrolyte and acid-base imbalances, administration of insulin if necessary.\n\n5 PHARMACOLOGICAL PROPERTIES\n\n5.1 PHARMACODYNAMIC PROPERTIES\n\nThe solution contains equimolar proportions of sodium and chloride corresponding to one fifth the physiological\n\nconcentration in the plasma. In addition this solution also contains 4 % (w/v) of carbohydrate in the form of glucose.\n\nThe solution is mainly intended to supply free water in cases of dehydration.\n\n5.2 PHARMACOKINETIC PROPERTIES\n\nThe total sodium content of the body is ca. 80 mmol/kg of which ca. 97 % is extracellular and ca. 3 % intracellular.\n\nThe daily turnover is ca. 100-180 mmol (corresponding to 1.5-2.5 mmol/kg body weight).\n\nChloride is exchanged for hydrogen carbonate in the tubule system and is, thus, involved in the regulation of the acid\n\nbase balance.\n\nOn infusion glucose is first distributed in the intravascular space and then is taken up into the intracellular space.\n\nIn glycolysis glucose is metabolized to pyruvate or to lactate. Lactate can be partially re-introduced into the glucose\n\nmetabolism (Cori cycle). Under aerobic conditions pyruvate is completely oxidized to carbon dioxide and water. The\n\nfinal products of the complete oxidation of glucose are eliminated via the lungs (carbon dioxide) and the kidneys\n\n(water).\n\n5.3 PRECLINICAL SAFETY DATA\n\nThere are no pre-clinical data of relevance to the prescriber which are additional to those already stated in other\n\nsections of the SPC.\n\n6 PHARMACEUTICAL PARTICULARS\n\n6.1 LIST OF EXCIPIENTS\n\nWater for injections\n\n6.2 INCOMPATIBILITIES\n\nWhen mixing with other medicaments it should be remembered that 0.18 % w/v Sodium Chloride and 4 % w/v\n\nGlucose Intravenous Infusion BP Solution for Infusion has an acid pH which can cause precipitation in the mixture.\n\nIRISH MEDICINES BOARD\n\n__\n\n_Date Printed 08/04/2008_\n\n_CRN 2041821_\n\n_page number: 4_\n\n6.3 SHELF LIFE\n\nUnopened: 3 years\n\nOnce opened: Use immediately. Discard any unused contents.\n\n6.4 SPECIAL PRECAUTIONS FOR STORAGE\n\nDo not store above 25°C. Store in original container.\n\n6.5 NATURE AND CONTENTS OF CONTAINER\n\nContainers of low-density polyethylene with integral on-welded closure of the same material. The closure contains a\n\nrubber disc.\n\nContents: 500 ml, 1000 ml.\n\n6.6 SPECIAL PRECAUTIONS FOR DISPOSAL AND OTHER HANDLING\n\nSingle-dose container. Discard unused contents.\n\nOnly to be used if the solution is clear, free from visible solid particles and the container or its closure do not show\n\nvisible signs of damage.\n\n7 MARKETING AUTHORISATION HOLDER\n\nB. Braun Medical Limited\n\n3 Naas Road Industrial Park\n\nDublin 12\n\n8 MARKETING AUTHORISATION NUMBER\n\nPA 179/3/6\n\n9 DATE OF FIRST AUTHORISATION/RENEWAL OF THE AUTHORISATION\n\nDate of first authorisation: 01 April 1983\n\nDate of last renewal: 01 April 2008\n\n10 DATE OF REVISION OF THE TEXT\n\nApril 2008\n\nIRISH MEDICINES BOARD\n\n_____________________________________________________________________________________\n\n_Date Printed 08/04/2008_\n\n_CRN 2041821_\n\n_page number: 5_\n ');
Query OK, 1 row affected (1 min 9.517 sec)

Apart the name of the field and the version it looks like the same insert with very different timings, I am moving to v25 and see if there are any differences.

I have tested with different text sizes and cutting it down to 256chars cuts the insert to 0.5sec/row see here:

INSERT INTO rt_products (name, doc_text) VALUES (‘0.18 % W/V SODIUM CHLORIDE AND 4 % W/V GLUCOSE INT’, ’ \n\nIRISH MEDICINES BOARD ACTS 1995 AND 2006\n\nMEDICINAL PRODUCTS(CONTROL OF PLACING ON THE MARKET)REGULATIONS,2007\n\n(S.I. NO.540 OF 2007)\n\nPA0179/003/006A\n\nCase No: 2041821\n\nThe Irish Medicines Board in exerciseof the powers conferred on it by the above mentioned Regulations hereby grants to\n\nB. BRAUN MEDICAL LIMITED\n\n3 NAAS ROAD INDUSTRIAL PARK, DUBLIN12, IRELAND\n\nan authorisation, subject to the provisions of the said Regulations, in respect of the product\n\n0.18 % W/V SODIUM CHLORIDE AND 4 % W/V GLUCOSE INTRAVENOUS INFUSION BP SOLUTION FOR INFUSION, 500 ML AND 1000 ML\n\nThe particulars of which are set out in Part I and Part II of the attached Schedule. The authorisation is also subject to the general conditions as\n\nmay be specified in the said Regulations as listed on the reverse of this document.\n\nThis authorisation, unless previously revoked, shall continue in force from 01/04/2008.\n\nSigned on behalf of the Irish Medicines Board this’);
Query OK, 1 row affected (0.819 sec)

INSERT INTO rt_products (name, doc_text) VALUES (‘0.18 % W/V SODIUM CHLORIDE AND 4 % W/V GLUCOSE INT’, ’ \n\nIRISH MEDICINES BOARD ACTS 1995 AND 2006\n\nMEDICINAL PRODUCTS(CONTROL OF PLACING ON THE MARKET)REGULATIONS,2007\n\n(S.I. NO.540 OF 2007)\n\nPA0179/003/006A\n\nCase No: 2041821\n\nThe Irish Medicines Board in exerciseof the powers conferred on it by the above mentioned Regulations hereby grants to\n\nB. BRAUN MEDICAL LIMITED\n\n3 NAAS ROAD INDUSTRIAL PARK, DUBLIN12, IRELAND\n\nan authorisation, subject to the provisions of the said Regulations, in respect of the product\n\n0.18 % W/V SODIUM CHLORIDE AND 4 % W/V GLUCOSE INTRAVENOUS INFUSION BP SOLUTION FOR INFUSION, 500 ML AND 1000 ML\n\nThe particulars of which are set out in Part I and Part II of the attached Schedule. The authorisation is also subject to the general conditions as\n\nmay be specified in the said Regulations as listed on the reverse of this document.\n\nThis authorisation, unless previously revoked, shall continue in force from 01/04/2008.\n\nSigned on behalf of the Irish Medicines Board this\n\n________________\n\nA person authorised in that behalf by the said Board.\n\nIRISH MEDICINES BOARD\n\n____________________________________\n\n_Date Printed 08/04/2008**\n\n_CRN 2041821\n\n_page number: 1\n\nPART II\n\nSUMMARY OF PRODUCT CHARACTERISTICS\n\n1 NAME OF THE MEDICINAL PRODUCT\n\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Infusion BP, Solution for Infusion.\n\n2 QUALITATIVE AND QUANTITATIVE COMPOSITION\n\nFor a full list of excipients, see section 6.1.\n\n3 PHARMACEUTICALFORM\n\nSolution for infusion\n\nA clear, colourless, sterile and non-pyrogenic aqueous solution.\n\n4 CLINICAL PARTICULARS\n\n4.1 THERAPEUTIC INDICATIONS\n\nFor use in prophylactic and replacement therapy requiring the use of glucose and sodium chloride.\n\n4.2 POSOLOGY AND METHOD OF ADMINISTRATION\n\n4.2.1 DOSAGE\n\nIn accordance with fluid, electrolyte and energy requirements:\n\nNot more than 40 ml/kg body weight per day, corresponding to 1.7g glucose/kg body weight per day.\n\n_Infusion and drop rate:\n\nNot more than 5 mg/kg body weight per hour, corresponding to 0.2 g glucose/kg bodyweight per hour, or not more\n\nthan 1.7 drops/kg weight per minute.\n\nThe solution contains per\n\n500 ml\n\n1000 ml\n\nSodium chloride\n\n0.90 g\nn1.80 g\n\nAnhydrous Glucose\n\n20.00 g\n\n40.00 g\n\nas Glucose Monohydrate\n\nEach litre provides:\n\nElectrolytes:\n\nSodium\n\n31\n\nmmol/l\n\nChloride\n\n31\n\nmmol/l\n\nCalorific value:\n\n668 kJ/1 = 160 kcal/1\n\nTheoretical osmolarity:\n\n284\n\nmOsm/l\n\nTitration acidity (to pH 7.4):\n\n<0.5 mmol/l\n\npH:\n\n3.5 – 5.5\n\nIRISH MEDICINES BOARD’);
Query OK, 1 row affected (18.115 sec)

Apart the fact that you may have better hw or more memory still it seems that there may be a buffering problem and when you hit it the timings go over the roof.

Now trying the same on V25 …

4

Further testing:

I ran this on my local Mac, not a fast machine by any means:

starting daemon version ‘25.0.0 ce3c27828@26032712 (columnar 13.0.0 e60b083@26032708) (secondary 13.0.0 e60b083@26032708) (knn 13.0.0 e60b083@26032708) (embeddings 1.1.1 e60b083@26032708)’ …

INSERT INTO rt_products (name, doc) VALUES (‘0.18 % W/V SODIUM CHLORIDE AND 4 % W/V GLUCOSE INT’, ’ \n\nIRISH MEDICINES BOARD ACTS 1995 AND 2006\n\nMEDICINAL PRODUCTS(CONTROL OF PLACING ON THE MARKET)REGULATIONS,2007\n\n(S.I. NO.540 OF 2007)\n\nPA0179/003/006A\n\nCase No: 2041821\n\nThe Irish Medicines Board in exerciseof the powers conferred on it by the above mentioned Regulations hereby grants to\n\nB. BRAUN MEDICAL LIMITED\n\n3 NAAS ROAD INDUSTRIAL PARK, DUBLIN12, IRELAND\n\nan authorisation, subject to the provisions of the said Regulations, in respect of the product\n\n0.18 % W/V SODIUM CHLORIDE AND 4 % W/V GLUCOSE INTRAVENOUS INFUSION BP SOLUTION FOR INFUSION, 500 ML AND 1000 ML\n\nThe particulars of which are set out in Part I and Part II of the attached Schedule. The authorisation is also subject to the general conditions as\n\nmay be specified in the said Regulations as listed on the reverse of this document.\n\nThis authorisation, unless previously revoked, shall continue in force from 01/04/2008.\n\nSigned on behalf of the Irish Medicines Board this\n\n________________\n\nA person authorised in that behalf by the said Board.\n\nIRISH MEDICINES BOARD’);
Query OK, 1 row affected (0.327 sec)

INSERT INTO rt_products (name, doc) VALUES (‘0.18 % W/V SODIUM CHLORIDE AND 4 % W/V GLUCOSE INT’, ’ \n\nIRISH MEDICINES BOARD ACTS 1995 AND 2006\n\nMEDICINAL PRODUCTS(CONTROL OF PLACING ON THE MARKET)REGULATIONS,2007\n\n(S.I. NO.540 OF 2007)\n\nPA0179/003/006A\n\nCase No: 2041821\n\nThe Irish Medicines Board in exerciseof the powers conferred on it by the above mentioned Regulations hereby grants to\n\nB. BRAUN MEDICAL LIMITED\n\n3 NAAS ROAD INDUSTRIAL PARK, DUBLIN12, IRELAND\n\nan authorisation, subject to the provisions of the said Regulations, in respect of the product\n\n0.18 % W/V SODIUM CHLORIDE AND 4 % W/V GLUCOSE INTRAVENOUS INFUSION BP SOLUTION FOR INFUSION, 500 ML AND 1000 ML\n\nThe particulars of which are set out in Part I and Part II of the attached Schedule. The authorisation is also subject to the general conditions as\n\nmay be specified in the said Regulations as listed on the reverse of this document.\n\nThis authorisation, unless previously revoked, shall continue in force from 01/04/2008.\n\nSigned on behalf of the Irish Medicines Board this\n\n________________\n\nA person authorised in that behalf by the said Board.\n\nIRISH MEDICINES BOARD\n\n____________________________________\n\n_Date Printed 08/04/2008**\n\n_CRN 2041821\n\n_page number: 1\n\nPART II\n\nSUMMARY OF PRODUCT CHARACTERISTICS\n\n1 NAME OF THE MEDICINAL PRODUCT\n\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Infusion BP, Solution for Infusion.\n\n2 QUALITATIVE AND QUANTITATIVE COMPOSITION\n\nFor a full list of excipients, see section 6.1.\n\n3 PHARMACEUTICALFORM\n\nSolution for infusion\n\nA clear, colourless, sterile and non-pyrogenic aqueous solution.\n\n4 CLINICAL PARTICULARS\n\n4.1 THERAPEUTIC INDICATIONS\n\nFor use in prophylactic and replacement therapy requiring the use of glucose and sodium chloride.\n\n4.2 POSOLOGY AND METHOD OF ADMINISTRATION\n\n4.2.1 DOSAGE\n\nIn accordance with fluid, electrolyte and energy requirements:\n\nNot more than 40 ml/kg body weight per day, corresponding to 1.7g glucose/kg body weight per day.\n\n_Infusion and drop rate:\n\nNot more than 5 mg/kg body weight per hour, corresponding to 0.2 g glucose/kg bodyweight per hour, or not more\n\nthan 1.7 drops/kg weight per minute.\n\nThe solution contains per\n\n500 ml\n\n1000 ml\n\nSodium chloride\n\n0.90 g\nn1.80 g\n\nAnhydrous Glucose\n\n20.00 g\n\n40.00 g\n\nas Glucose Monohydrate\n\nEach litre provides:\n\nElectrolytes:\n\nSodium\n\n31\n\nmmol/l\n\nChloride\n\n31\n\nmmol/l\n\nCalorific value:\n\n668 kJ/1 = 160 kcal/1\n\nTheoretical osmolarity:\n\n284\n\nmOsm/l\n\nTitration acidity (to pH 7.4):\n\n<0.5 mmol/l\n\npH:\n\n3.5 – 5.5\n\nIRISH MEDICINES BOARD\n\n**__\n\n_Date Printed 08/04/2008**\n\n_CRN 2041821\n\n_page number: 2\n\n4.2.2 METHOD AND ROUTE OF ADMINISTRATION\n\nIntravenous infusion.\n\n4.3 CONTRAINDICATIONS\n\n0.18 % w/v Sodium Chloride and 4 % w/v Glucose Intravenous Infusion BP, solution for Infusion should not beused’);
Query OK, 1 row affected (6.929 sec)

Insert with the full text (original record) takes close to 1minute

The limit seems to be, on my hw, around 1588 chars, if I add 1 more char the insert timings double and then go awry from there.

A few questions:

  • does the model need to be completely in memory (I may not have enough ram to store the whole thing) ?
  • are there any parameters that can be used to control buffering or memory allocation ?

Issues may be related to the model (I am planning to use paraphrase-multilingual-MiniLM-L12-v2 which is a bit bigger and takes longer to process the text) but also to memory available on hw (?) or some buffering. It seems there is a huge difference in timings once you hit a certain text length.

Unfortunately I do not know enough about the inner workings to make any guesses but I am happy to test any suggestions.

Any ideas ?

5

I’d like to reproduce it on my end and debug. Can you please provide a full reproducible case starting from create table. Best if it’s full, but minimal, e.g. with text like abc abc abc ... and only one field etc.

6

Steps to reproduce the problem.

Manticore version: starting daemon version ‘25.0.0 ce3c27828@26032712 (columnar 13.0.0 e60b083@26032708) (secondary 13.0.0 e60b083@26032708) (knn 13.0.0 e60b083@26032708) (embeddings 1.1.1 e60b083@26032708)’

Hardware: MacBook Air M1

I use plain mode so no create statement, the rt table is defined in the conf file.

less /opt/homebrew/etc/manticoresearch/manticore.conf

searchd {
listen = 9306:mysql
log = /opt/homebrew/var/log/manticore/searchd.log
query_log = /opt/homebrew/var/log/manticore/query.log
pid_file = /opt/homebrew/var/run/manticore/searchd.pid
}

table rt_products {
type = rt
path = /opt/homebrew/var/manticore/rt
rt_field = doc
rt_attr_float_vector = emb_vector
knn = {“attrs”:\[{“name”:“emb_vector”,“type”:“hnsw”,“hnsw_similarity”:“L2”,“hnsw_m”:16,“quantization”:“8bit”,“hnsw_ef_construction”:200,“model_name”:“sentence-transformers/all-MiniLM-L6-v2”,“from”:“doc”}\]}
}

mysql> describe rt_products;                                                                                                                          ±-----------±-------------±---------------+
| Field      | Type         | Properties     |
±-----------±-------------±---------------+
| id         | bigint       |                |
| doc        | text         | indexed stored |
| emb_vector | float_vector | knn            |
±-----------±-------------±---------------+
3 rows in set (0.000 sec)

mysql> select * from rt_products\G
Empty set (0.004 sec)
— 0 out of 0 results in 1ms 229us —

mysql> INSERT INTO rt_products (doc) VALUES (‘abc abc abc abc abc abc abc abc abc abc abc abc’);
Query OK, 1 row affected (0.035 sec)

mysql> INSERT INTO rt_products (doc) VALUES (‘abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc’);
Query OK, 1 row affected (0.086 sec)

mysql> INSERT INTO rt_products (doc) VALUES (‘abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc’);
Query OK, 1 row affected (0.143 sec)

mysql> INSERT INTO rt_products (doc) VALUES (‘abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc’);
Query OK, 1 row affected (0.336 sec)

mysql> INSERT INTO rt_products (doc) VALUES (‘abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc’);
Query OK, 1 row affected (2.816 sec)

mysql> INSERT INTO rt_products (doc) VALUES (‘abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc abc’);
Query OK, 1 row affected (7.262 sec)

Happy to provide additional data or do more tests.

Thanks